>> On Thu, 7 Dec 2006 14:13:01 -0500, Lawrence Clark <Larry_Clark AT 
>> THRUWAY.STATE.NY DOT US> 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" <asr AT ufl DOT edu> 
>> 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