ADSM-L

Re: transmitting the result of an sql query to a script ? + loop struture ?

2001-11-26 18:03:28
Subject: Re: transmitting the result of an sql query to a script ? + loop struture ?
From: bbullock <bbullock AT MICRON DOT COM>
Date: Mon, 26 Nov 2001 16:00:47 -0700
        As yet another example of the numerous ways to do the same task in
unix. Here's a simple script I wrote a while back to do the same task:

________
for i in $( dsmadmc -se=xxx -id=xxx -password=xxx "select PROCESS_NUM from
processes where PROCESS like 'Space Reclamation'" |grep '[0-9]' |grep -v
'[A-z]')
'[A-z]')
do
 dsmadmc -se=xxx -id=xxx -password=xxx can proc $i
done
__________

        As for the original question: I don't know of a way to do it within
the TSM server itself (with either a script or a macro). I'm not saying that
it can't be done, only that I don't know of a way.

Thanks,
Ben