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

3). I can now strip off the header lines and execute the commands

4). from admin : macro <filename> (must be in current directory admin
command line was started from)


RESULT:

IBM Tivoli Storage Manager
Command Line Administrative Interface - Version 5, Release 3, Level
4.0
(c) Copyright by IBM Corporation and other(s) 1990, 2006. All Rights
Reserved.

Session established with server BACKUP: AIX-RS/6000
  Server Version 5, Release 3, Level 3.0
  Server date/time: 12/07/06   14:00:25  Last access: 12/07/06
13:59:43

ANS8000I Server command: 'select 'move data' , volume_name from volumes
where st
gpool_name='CPSATABG''
move data       /var/diskpool/satacopyvola/00008EB1.BFS
move data       /var/diskpool/satacopyvola/00008EB7.BFS
move data       /var/diskpool/satacopyvola/00008EBD.BFS
move data       /var/diskpool/satacopyvola/00008EC3.BFS
move data       /var/diskpool/satacopyvola/00008EC9.BFS
move data       /var/diskpool/satacopyvola/00008ECF.BFS
move data       /var/diskpool/satacopyvola/00008ED5.BFS
move data       /var/diskpool/satacopyvola/00008EDC.BFS
move data       /var/diskpool/satacopyvola/00008EE2.BFS
move data       /var/diskpool/satacopyvola/00008EE8.BFS
move data       /var/diskpool/satacopyvola/00008EEE.BFS
move data       /var/diskpool/satacopyvola/00008EF4.BFS
move data       /var/diskpool/satacopyvola/00008EFA.BFS








The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain information that is confidential, privileged, and/or otherwise exempt 
from disclosure under applicable law.  If this electronic message is from an 
attorney or someone in the Legal Department, it may also contain confidential 
attorney-client communications which may be privileged and protected from 
disclosure.  If you are not the intended recipient, be advised that you have 
received this message in error and that any use, dissemination, forwarding, 
printing, or copying is strictly prohibited.  Please notify the New York State 
Thruway Authority immediately by either responding to this e-mail or calling 
(518) 436-2700, and destroy all copies of this message and any attachments.