ADSM-L

Re: SQL select and update command

2001-10-10 16:37:09
Subject: Re: SQL select and update command
From: Mark Stapleton <stapleto AT BERBEE DOT COM>
Date: Wed, 10 Oct 2001 16:35:19 -0400
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)
Mark Stapleton (stapleton AT berbee DOT com)
<Prev in Thread] Current Thread [Next in Thread>