RE: IBM Query generated file to CSV?

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

I use SEQUEL. It generates rock solid CSV files.

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
Sent: Monday, July 30, 2012 3:35 PM
To: Midrange Systems Technical Discussion
Subject: Re: IBM Query generated file to CSV?

On Mon, Jul 30, 2012 at 3:26 PM,  <rob@xxxxxxxxx> wrote:
> I hate CPYTOIMPF because of IBM's constant monkeying around with it every
> release but something like this may work
> CPYTOIMPF FROMFILE(X)
>           STMFCCSID(*PCASCII)
>           FLDDLM(',')

Starting with V5R4, you can get reasonably close to Excel-style CSV by
specifying RMVBLANK(*TRAILING) on the CPYTOIMPF command.

On V5R2, the CPYTOIMPF command is incapable of doing even a decent job
of Excel-style CSV (mainly because it is clueless about quotation
marks within your data).

John