ADSM-L

AW: SQL select and update command

2001-10-02 11:25:45
Subject: AW: SQL select and update command
From: "Baines, Paul" <Paul.Baines AT PARTNER.COMMERZBANK DOT COM>
Date: Tue, 2 Oct 2001 17:20:34 +0200
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 <=