>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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.