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
|
|
|