Re: CSV file creation

What I did in a similar situation was to define a new PF with no key, just 
like the file to be transferred (all alpha fields), and with fields for 
the csv values filled by default.  Then a new program reads from the 
already existing file and populates the new flat file.  One big advantage 
is the EVAL opcode to turn numeric fields to alpha fields with an 'N' edit 
code.


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




"Saunders, Martin P" <Martin.Saunders@capgemini.co.uk>
Sent by: owner-rpg400-l@midrange.com
12/13/2000 05:00 AM
Please respond to RPG400-L

 
        To:     "'RPG400-L@midrange.com'" <RPG400-L@midrange.com>
        cc: 
        Subject:        CSV file creation

I have an RPG program which is currently populating a DB file with data.
There is a requirement for this data to be sent via ftp to a third party 
in
csv format.

What is the best/easiest way to do this?

Should the RPG program be changed to output to a flat file with comma
separators or is there another way to convert the DB file to a csv file
without leaving the 400 since the file will be transferred from the AS/400
directly?  Would this involve going outside the QSYS file system (I have
never done this)?

The ftp part won't be a problem as we already ftp flat files to other 
third
parties, but these people are insisting on csv.

Thanks in advance

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




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