Re: Getting a Handle on RPG’s Open Access

On Tue, Dec 23, 2014 at 9:42 AM, Alan Cassidy <ACassidy@xxxxxxxxxxxxxx> 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.

John Y.