Re: your mail -- MIDRANGE-L

Hello,

On Tue, 21 Nov 2006, fbocch2595@xxxxxxx wrote:


Is there a default file name?

Hmmm... I'm not exactly sure what you mean by that. Let's review thecode again, and maybe that'll answer your question.


Here's the original code (this is a QShell commnd) that was posted:

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

This command line runs the "db2" program. It passes it a parametercontaining an SQL statement. At this point in the process, the SQLstatement is just string that will be passed as a parameter to the DB2program. Here's the parameter it's passing:


"select wgtbra || ',' || char(agtnoa) || ',' || agtnaa from anvdev.agtmas"

The DB2 program takes that parameter and executes it as an SQL statement,and generates a report from the result. It writes that report to theprogram's "stdout" stream.

This SQL statement explicitly lists the filename as "anvdev.agtmas" (thisis SQL naming convention. It's equivalent to ANVDEV/AGTMAS in our morefmailiar naming convention)

By default, the "stdout" of the db2 program would be printed on thescreen. So I guess you could call that a "default" filename. But in thisexample, it's not. Instead, it's being redirected to become the input ofthe 'sed' command. That's what the pipe operator does, it redirects theoutput from one program to the input of another program.


In this case, you have this:

    db2 (parms) | sed (parms)

So the output of the db2 program is redirected to the input of the sedprogram. By default, sed reads it's input from the 'stdin' data stream.If you don't direct the input from another program or file, it willdefault to receiving input from the keyboard. But in this case, it'sinput is coming from the output of the db2 command.

Sed then prints out any lines that contain a comma. Thus, it effectively"filters" out any non-comma lines. It writes the result to it's ownstdout stream

Again, this standard output would be printed on the screen by default.However, in this case, it's redirected to a file. That's what the >operator does, it redirects standard output to a disk file.

So, once again, removing the parmeters for clarity, the statement lookslike this:


    db2 (parms) | sed (parms) > /mxp/mxpsql.csv

The db2 program runs the SQL statement listed in it's parameter. It writesthe output to the sed program. The sed program filters out all non-commalines and writes the output to the /xmp/mxpsql.csv stream file in theIFS.


Does that answer your question?