MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2014

RE: Data Transfer from i series to excel file or display give hexadecimal values fro date



fixed

Vik,
As you may already know, the value displayed
appears to be the hex value of the EBCDIC
characters for the date, so as Rob points
out, maybe the date is not translated because
the data is being transferred from a file
where the CCSID is 65535 - which is read
by the operating system as "no translation".

So in the "Receive File From Host..." Actions
menu, on the File - Properties window, maybe
check "Convert CCSID 65535" ?



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vikhyath Kamath
Sent: Friday, February 14, 2014 6:31 AM
To: Midrange Systems Technical Discussion
Subject: Data Transfer from i series to excel file or display give hexadecimal values fro date

Hi,
 
The user seemed to complain of this first, but when I check I to data transfer a file from iseries to display or file, the date appear F0F961F0F261F1F9F2F5.
 
I assumed its something to with IBM iseries access for windows (she was using V5R4), so had her install V6R1 IBM i series access for windows.
We use V6R1 operating system.
 
Is there a PTF or software update that's required to fix this?
 
Regards,
Vik.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact