ADSM-L

Re: SQL Output

2002-04-24 13:28:32
Subject: Re: SQL Output
From: Todd Lundstedt <Todd_Lundstedt AT VIA-CHRISTI DOT ORG>
Date: Wed, 24 Apr 2002 12:28:25 -0500
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
<Prev in Thread] Current Thread [Next in Thread>