Re: your mail

Is there a default file name?   
 
 
-----Original Message-----
From: midrange-l@xxxxxxxxxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Sent: Mon, 20 Nov 2006 10:06 PM
Subject: Re: your mail

db2 "select agtbra || ',' || char(agtnoa) || ',' || agtnaa from
anvdev.agtmas" | sed -n '/,/p'  > /mxp/mxpsql.csv

The QSHELL manual didn't provide me with any clues.

Here's the page in the Information Center that describes the "sed" 
utility:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzahz/sed.htm

Here's what it says about -n:

   -n   By default, each line of input is echoed to the standard output
        after all of the commands have been applied to it. The -n option
        suppresses this behavior.

Here's what it says about p:

[2addr]p
     Write the pattern space to standard output.

So... the command line "sed -n '/,/p'" would print only the lines that 
have commas in them.  The -n suppresses printing of the other lines, the 
/,/ tells it to search for a comma, ands the p tells it to print matching 
lines.

To see why this is needed, try running the command without the "sed" in 
it. You'll see that it outputs some text at the start and end of the 
query, but none of that text contains a comma.  Basically, by stripping 
every line that doesn't contain a comma, you've deleted those extra lines 
of output.

The quotes around /,/ aren't really necessary, since neither / nor , is a 
special character.  If you like, you can just code sed -n /,/ (the same 
thing, but without the single quotes)

Good luck