Re: [COBOL400-L] Downloading from COBOL to a .csv

[MichaelQuigley@xxxxxxxxxx]

   >date: Tue, 9 Mar 2004 08:04:53 -0600
   >from: Kelly Cookson <KCookson@xxxxxxxxxxxx>
   >subject: RE: [COBOL400-L] Downloading from COBOL to a .csv
            .          .          .
            .          .          .
            .          .          .
   >By the way, if you don't want to write a CSV file to the IFS using COBOL,
   >you might try using COBOL to create a temporary DB2 database file, then
   use
   >the CL command CPYTOSTMF to write the temporary DB2 database file to an
   IFS
   >stream file. If you set the ENDLINFMT parameter to *FIXED you should get
   a
   >fixed width text file in the IFS. Microsoft Excel can open fixed width
   text
   >files.
   You could also try using CPYTOSTMF something like this:

   CPYTOIMPF FROMFILE(mylib/db2file)      
             TOSTMF('/home/mydir/test.csv')
             MBROPT(*REPLACE)              
             STMFCODPAG(*PCASCII)          
             RCDDLM(*CRLF)                  
   This will generate a .csv file in any IFS directly from a DB2 database
   file.  We've even put things on our IPCS or IXS (NT server -- whatever
   it's called now) using the /QNTC path in the IFS.

   Michael Quigley
   Systems-Analyst
   The Way International
   www.TheWay.org