Re: SQL select and update command
2001-10-10 17:00:35
Mark's response answers the specific case of the original
question quite well, but I'm curious if anyone knows if there is
a general solution to the question.
Having not upgraded any of our production servers past 3.1, I
only recently began looking at the rudimentary scripting that was
added with TSM and I wanted to do exactly this type of operation:
run a query, and use the result of the query in a subsequent
operation. I couldn't find any way that this was possible, and
ultimately had to abandon what I wanted to do and instead wrote a
(very redundant) 100 line macro file.
Just curious if anyone else has a generalized solution to the
problem at hand.
-- Tom
Thomas A. La Porte
DreamWorks SKG
tlaporte AT anim.dreamworks DOT com
On Wed, 10 Oct 2001, Mark Stapleton wrote:
>On Tue, 2 Oct 2001 11:06:31 -0400, it was written:
>>Could someone give me an example how to do a select and then run command
>>against the select reqult? For example, I want:
>>
>>Select volume_name from volumes where access!='READWRITE'
>>then
>>update volume the_result_from_select access=readwrite.
>
>Easy.
>
> upd vol * stg=<storage_pool_name> access=readwrite
>
>--
>Mark Stapleton (stapleton AT berbee DOT com)
>
>
|
|
|