AW: SQL select and update command

[Baines, Paul]

Slightly different query, but you should get the idea:


for i in `dsmadmc -se=xxxx -id=xxxx -password=xxxx -tab "select '!#!#',
volume_na
me from libvolumes where (volume_name not like 'F%' and status='Scratch') or
vol
ume_name in (select volume_name from volumes where volume_name not like 'F%'
and
 (devclass_name='DEVC_3590' and status='PENDING'))" | awk '/^!#!#/ {print
$2}'`
do
printf "============================\n"
printf "Checking out volume %s\n" $i
dsmadmc -se=xxxx -id=xxxx -password=xxxx "checkout libv robot_3494 $i
remove=no"
done


Mit freundlichen Gr��en - With best regards
Serdeczne pozdrowienia - Slan agus beannacht
Paul Baines
TSM/ADSM Consultant


-----Urspr�ngliche Nachricht-----
Von: Guan, Phillip [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 2. Oktober 2001 17:07
An: [EMAIL PROTECTED]
Betreff: SQL select and update command


Hi all,

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.

Thanks.

Best regards,
Phillip Guan