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

2001-11-27 Thread Robin Sharpe
Here's one that we use every day, and it works pretty well... from an AIX 4.3.3 machine. This kills any running reclaims: # Kill any reclaim processes that are running alias dsmadmc="dsmadmc -id=maestro -pa=admin" list_reclaim_pids() { dsmadmc select process_num from processes where process

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

2001-11-22 Thread PAC Brion Arnaud
rts in O.S. itself ?!!! :-(( Regards. Arnaud -Original Message- From: Baines, Paul [mailto:[EMAIL PROTECTED]] Sent: Donnerstag, 22. November 2001 12:01 To: [EMAIL PROTECTED] Subject: AW: transmitting the result of an sql query to a script ? + loop struture ? I can't think how you&#x

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

2001-11-22 Thread Baines, Paul
I can't think how you'd do it without a shell script. Try this (not tested!) for proc in `dsmadmc -se=xxx -id=xxx -password=xxx -tab "select '#!#!', process_num from processes where process='Space Reclamation'" | awk '/^#!#!/ {printf("%d\n", $2)}'` do dsmadmc -se=xxx -id=xxx -password=xxx -tab