Re: IBM Query generated file to CSV?

Hi Chuck -

On Mon, 30 Jul 2012 19:18:51 +0000, Chuck Lewis
<Chuck.Lewis@xxxxxxxxxxxxxxxxx> wrote:

We FTP files from our Power 7 to a bunch our suppliers and have never had a problem until now. We have a supplier that will only accept files in CSV format.

Of course we can download the file, import it into Excel and save it as a CSV but so much for automation...

Any of you wizards out there if this is possible?

You should be able to just build the CSV data in a physical file and
FTP it. We do that quite successfully.

For character fields I use a service program procedure that handles
the rules for CSV character values. (Hint: To make it easy, I enclose
all character values in quotes (") whether they contain a character
which requires it or not. The CSV standard allows this.)

For numeric fields I use edit code P (if I want zero values as a zero)
or edit code Q (if I want zero values as empty), wrapped inside
trimming.

Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.