Re: Convert Database file to CSV

True.

But:

- We do not konow which OS verion the OP is on.

- The ADDCOLNAM parameter will be using the field name (column name) as defined. With DDS those could be cryptic with 10 characters max.

Adding your own column headings may be more informative.

Just my 2 cents on this.

Regards,

Carel Teijgeler


Op 19-7-2016 om 21:13 schreef John Yeung:

On Tue, Jul 19, 2016 at 11:13 AM, Carel <coteijgeler@xxxxxxxxx> wrote:

If you want column headings, you need a query with a UNION; the
numeric/decimal values in columns have therefore to be converted to
character (using DIGITS).

Not necessarily. Very recently there was a thread discussing the
ADDCOLNAM parameter on modern versions of CPYTOIMPF. It's kind of
underdocumented, but it's there when you press F9 to show all
parameters.

John Y.