ADSM-L

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

2001-11-22 06:02:34
Subject: AW: transmitting the result of an sql query to a script ? + loop struture ?
From: "Baines, Paul" <Paul.Baines AT PARTNER.COMMERZBANK DOT COM>
Date: Thu, 22 Nov 2001 12:00:44 +0100
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 "cancel proc $proc"
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: transmitting the result of an sql query to a script ? + loop struture ?, Baines, Paul <=