Re: Getting a Handle on RPG’s Open Access

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

On Tue, Dec 23, 2014 at 4:00 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

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.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.