>> On Thu, 7 Dec 2006 14:13:01 -0500, Lawrence Clark <[EMAIL PROTECTED]> said:
> This was a bear trying to get output in a friendly form to execute as a > macro. Might be helpful to others. > What worked for me: > 1). I built the query in one file with redirtection in the command > line: > /home/root/bin/dsmcmdx "select 'move data', volume_name from volumes > where stgpo > ol_name='CPSATABG'" > DSMSQLTEXT > 2) I have the dsmadmc in another file with the -TAB option: > dsmadmc -id=<admin> -pa=<password> -TAB $1 *koff* >> On Tue, 05 Dec 2006 17:32:08 -0500, "Allen S. Rout" <[EMAIL PROTECTED]> said: } dsmadmc -dataonly -tab " select 'del vol ',volume_name,' wait=yes' where your_criterion_here " > something.macro I really like the SQL concatenation suggestion Bill made: dsmadmc -dataonly -tab " select 'del vol ' || volume_name || ' wait=yes' where your_criterion_here " > something.macro would be the revised suggestion. - Allen S. Rout
