Client Access truncating blanks

15 pts.
Tags:
AS/400
PC/Windows Connectivity
I have some files that I have transfered from a AS400 with client access and it is truncating the blanks at the end. How can I not have this done.I need the blanks to stay there.

Answer Wiki

Thanks. We'll let you know when a new response is added.

are you transferring from Excel or other unicode files? Is it truncating at about 512 chanracters? I had this problem and IBM told me that the data was bad. Of course, it was not bad. It has to do with “invariant characters”. Here is what IBM told me:

“First, let me explain what I mean by an invariant character. Letters like A-Z and numbers 0-9 are invariant. Their code point is the same in all code pages. When we are dealing with Unicode data and Excel, we can process more data if the data is invariant. We basically compress out the high order byte and store just the low order byte. So, an A in unicode would be 0×0040, but we could store it as 0×40. Some of the
records contain characters that are outside of the invariant range. For instance, column 13 (M) of row 2 contains single quotes which are 0×1920 rather than apostrophe’s (which are 0×0027) and “en dash” which is 0×1320 rather than hyphen which is 0x002D. When this happens, the
unicode characters cannot be compressed. So when we read the data from Excel and see that the data is in a non-compressed form, we only accept 511 characters (1022 bytes). For other records, all the characters are invariant and hence can be compressed, so we end up with 1022 characters
(bytes). Aside from that, when the data is sent to the iSeries, you
lose the non-invariant characters because they won’t translate to code page
37, so you have a data integrity problem as well. ”

If you have my problem then there is no workaround.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • JPLamontre
    try FTP transfert in fixed-format length, something like FTP ... .../... BIN SITE RECFM=FB SITE LRECL=25 GET or PUT BIN or not BIN ? try !
    0 pointsBadges:
    report
  • TomLiotta
    How about a little more description? What kind of transfer format are you requesting? There are fixed-format types. What exactly do you need? An example would be helpful since there are multiple types. I could list and describe the types, but it wouldn't do any good. The Client Access <help> already does that, so we know you don't want to read about it. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following