RE: Getting a Handle on RPG’s Open Access

Your OA handler is at the top of my list of next things to try, Jon. Just discovered it. (I've got to check more regularly on the IBM midrange press.. and your articles..) :)

Alan

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 Jon
Paris
Sent: Wednesday, December 24, 2014 1:14 PM
To: Rpg400 Rpg400-L
Subject: Re: Getting a Handle on RPG’s Open Access

My OA handler would have made all that much easier for you Alan … just
sayin’ <grin>


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Dec 24, 2014, at 11:58 AM, Alan Cassidy <ACassidy@xxxxxxxxxxxxxx>
wrote:

The other part that I brought up, which indeed is a different issue,
is a combination of the above property plus two more: (1) CSV data
actually has no explicit types whatsoever (as much as some folks want
it to), and (2) Excel (the program) aggressively coerces what it
believes to be numeric-looking data into actual numeric data (which
it
*does* distinguish from text).

"Aggressive" might even be understatement.

The implication being that if you write data to a CSV, and it's read
by Excel, you may not always get the data type you intended. Even
the headings can be interpreted in unintended ways. (The most
dramatic being the case where the heading of the first column is
'ID'!)

For one project I finally ditched CPYTOIMPF and converted every data field

to an alpha string, and on some of the numeric fields I had to specially add an
extra single-quote on the left to force Excel to make it alphanumeric. That
was a date, in ISO format!

----------------------------------------------------------------------
---------- 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.

----------------------------------------------------------------------
----------


--
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.

--
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.
--------------------------------------------------------------------------------