RE: AS/400 Database File to IFS CSV Format

Try writing an RPGIV program sometime to write DB2/400  files to the IFS in
CSV format.

You have much better control.  You can read one file chain to other files
and write an
amalgamated (mixture) of fields from numerous files to the IFS as one
record.  I also write the first record using literals (kinda like column
headings) for each column.  That way when you bring up the CSV file using
Excel, the first row has Real Column Headings so the user knows what each
column really is.

You can't do any of that with a generic CPY command.  Try using the API's
to write to the IFS one time and you'll be sold.  I have one
application(Green Screen) whenever a user updates the particular DB2 file,
and then presses F3 to exit the Maintenance program,   I re-write out the
CSV file.   So the spreadsheet(CSV File) is always insync with the AS/400's
data base.  The users love it.   Try running a program at night, to
summarize (Maybe) daily production or sales totals or something.  Write the
summarized info to the IFS.   The users come in in the morning and
yesterday's stats are already there.  No Downloading, No file Transfers,
Sweet.

BTW,  I'll be doing a session at COMMON on this process.

John Carr

---------------------------------------------
Bill,

     The *PCASCII is a keyword for the CPYTOSTMF command (STMFCODPAG
parameter).
Using CPYTOIMPF, I have had the best luck by pre-creating the stream file
once, then replacing records - or - you can specify a specific code page.

     Alex

I am on V4R3.  Either no PTF exists for the *PCASCII keyword or (shudder!)
IBM doesn't know about the PTF.  Can anyone give me the specific PTF number
to order for V4R3?  Or is this PTF only available on V4R4?



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---