Author: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Thu, 7 Dec 2006 14:13:01 -0500
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:
I would suggest another approach to the problem. Dsmc -id=xx -pa=xxx -dataonly <query >output Where query is a file containing your sql text and output is where you want the output to go. I use this
Sorry: That's what I get for trying to do it from memory. Here is the line I use in my scripts. dsmadmc -dataonly=yes -server=server -id=admin -password=pw <query Hope this helps. Gary Lee Senior Sys
Author: Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
Date: Thu, 7 Dec 2006 15:02:11 -0500
Yes, it worked but with problems I've had trying it other ways: dsmadmc -dataonly=yes -id=admin -pa=<password> "select 'move data', volume_name from volumes where stgpool_name='CPSATABG'" > xyz 1). r
Author: William Boyer <bjdboyer AT COMCAST DOT NET>
Date: Thu, 7 Dec 2006 15:32:11 -0500
Couple suggestions... 1. there is the -OUTFILE= parameter to specify the output of the dsmadmc command. 2. use the SQL concatenation operator select 'move data ' || volume_name from volumes where stg