Re[2]: AS/400 Database File to IFS CSV Format

     In addition to this, a logical file could be defined over the 
     physical file to automagically change the packed values to signed 
     numeric, which is transfered as if it were character data. Used to 
     use this often for PC Support file transfers. Currently, though, 
     I'd stick with CPYTOIMPF.
     
     eric.delong@pmsi-services.com


______________________________ Reply Separator _________________________________
Subject: RE: AS/400 Database File to IFS CSV Format 
Author:  <MIDRANGE-L@midrange.com> at INET_WACO
Date:    8/4/00 1:31 AM


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


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