Re: Getting a Handle on RPG’s Open Access -- RPG400-L

I did a little googling - came up with this page -

http://www-01.ibm.com/support/docview.wss?uid=nas8N1015157

It says that the ORDERBY parameter is available from 6.1 - you have to apply a PTF to get it.

R610: SI44866 (APAR: SE48718)
R710: SI44871 (APAR: SE49612)

I think the column name parameter is ADDCOLNAM - there's a parallel on the CPYFRMIMPF command, RMVCOLNAM, to start the import with row 2. Documented on developerworks at

http://tinyurl.com/mmnozvq

Vern

On 12/23/2014 8:42 AM, Alan Cassidy wrote:

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

I've used the API's for directly writing column headings for the CSV, but in case this helps...

If you're using the CPYTOIMPF command to copy a database file to the CSV file in IFS, at some point, IBM added two new (undocumented far as I can tell) parameters to the CPYTOIMPF command. You have to use F9 to see them.

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.

The *SYS option uses the DDS short-names as column headings.
I don't remember whether the *SQL option uses the SQL-long-name, or the ALIAS name.

Alan Cassidy
Software Engineer
Hospital Physician Partners
954-981-6383 ext. 3433 – Direct phone
786-380-9236 - Mobile phone
acassidy@xxxxxxxxxxxxxx
www.hppartners.com

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Smith, Mike
Sent: Monday, December 22, 2014 4:25 PM
To: RPG programming on the IBM i / System i (rpg400-l@xxxxxxxxxxxx)
Subject: Getting a Handle on RPG’s Open Access

I’ve been working through Jon and Susans example to write a CSV file on the
IFS.
I have it working, but I’m not sure how/if I can write a line with headings?

Thanks
MIke
NOTICE: This message, including any attachment, is intended as a
confidential and privileged communication. If you have received this
message in error, or are not the named recipient(s), please immediately
notify the sender and delete this message.
--
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.

--------------------------------------------------------------------------------
Confidentiality Notice: This email may contain confidential information or information covered under the Privacy Act, 5 USC 552(a), and/or the Health Insurance Portability and Accountability Act (PL 104-191) and its various implementing regulations and must be protected in accordance with those provisions. It contains information that is legally privileged, confidential or otherwise protected from use or disclosure. This e-mail message, including any attachments, is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. You, the recipient, are obligated to maintain it in a safe, secure and confidential manner. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Thank you.
--------------------------------------------------------------------------------