Re: SQL Output
2002-04-24 13:28:32
If you are doing this from the command line in AIX.....
dsmadmc -id=<yourID> -password=<yourPW> "select whatever from whereever,
etc" | tail +XX | grep -v YY > new_filename
If you are doing this to a file that was created from the dsmadmc client
already.. it is very similar...
cat <filename> | tail +XX | grep -v YY > new_filename
where XX = the number of rows you want removed from the top
where YY = some unique text in the line you want to exclude
David E
Ehresman To: ADSM-L AT VM.MARIST DOT EDU
<deehre01@LOUIS cc:
VILLE.EDU> Subject: SQL Output
Sent by: "ADSM:
Dist Stor
Manager"
<ADSM-L AT VM DOT MARI
ST.EDU>
04/24/02 12:15
PM
Please respond
to "ADSM: Dist
Stor Manager"
I there a way to get JUST the output from a select statement into a file
without the TSM version header info at the beginning and the condition
code at the end?
This is TSM 4.2 on Aix 5.1.
David
|
|
|