RE: AS/400 Database File to IFS CSV Format

In similar circumstances I've chosen to define a physical file with the 
fields as alpha fields (even if they are numeric) and I define the csv 
fields right in to it with the default values of '","' and '"' as needed.

The advantage is that numeric fields can be sent to the physical file with 
a left side minus sign and the decimal point included.  Then, a simple FTP 
or e-mail of the file finishes the job.

_______________________
Booth Martin
Booth@MartinVT.com
http://www.MartinVT.com
_______________________




"Alex Moore" <alexm@ellishosiery.com>
Sent by: owner-midrange-l@midrange.com
08/03/2000 08:08 PM
Please respond to MIDRANGE-L

 
        To:     <MIDRANGE-L@midrange.com>
        cc: 
        Subject:        RE: AS/400 Database File to IFS CSV Format

Bill,

                 Use

                 CPYTOIMPF FROMFILE(THELIBRARY/THEFILE THEMEMBER)
          TOSTMF(thestreamfile)

                 The default is to create a comma delimited file, although 
you have pleanty
of other options.  Make sure you have current PTFs, or pre-create your
stream file.

                 Alex Moore

[mailto:owner-midrange-l@midrange.com]On Behalf Of Reger, Bill
Sent: Thursday, August 03, 2000 4:53 PM
To: 'Midrange-L'
Subject: AS/400 Database File to IFS CSV Format

, we need to send the file in a CSV (comma
separated) format.  I thought about using the CPYTOSTMF command to get the
file to the IFS and then to FTP the file from the IFS.  But I don't see an
option on the CPYTOSTMF to convert the file to CSV on the way.  Anyone 
have
any ideas for me?

+---
| 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
+---




+---
| 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
+---