AW: SQL select and update command
2001-10-02 11:25:45
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- AW: SQL select and update command,
Baines, Paul <=
|
|
|