Re: Getting a Handle on RPG’s Open Access

On 23-Dec-2014 09:03 -0600, Henrik Rützou wrote:

On Tue, Dec 23, 2014 at 4:00 PM, John Yeung wrote:

On Tue, Dec 23, 2014 at 9:42 AM, Alan Cassidy wrote:

I'm at 7.1, so this is "as of" 7.1.

[new CPYTOIMPF parameters]

ORDERBY() - A list in SQL-OrderBy-clause format of the sort
fields...
COLHDG() - If you want column headings, this parameter gives you
a choice of *NONE, *SQL, or *SYS.

Well I'll be. That's handy! The second parameter is actually
ADDCOLNAM.
I agree with you that it's undocumented, or at least
under-documented. When I try to bring up the parameter-level help,
it says no help is available.

As much as I have hated this command (at least as much as Rob has),
I will say that it has become a viable way to create CSVs. I
believe there are still some corner cases that it doesn't handle as
well as it could, but it's definitely very usable now. Better than
what a lot of people would write when rolling their own.

The problem of these "generic" DB to CSV tools is that is partly not
usable since the DB/CSV formats seldom match each other

Easy enough to CREATE VIEW to make them match; can be done both for export and import. But like most of this sub-thread of the discussion regarding the [enhancements to the] export utility, clearly we have gone off-topic.