Client Access truncating blanks

25 pts.
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 0x0040, but we could store it as 0x40. 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 0x1920 rather than apostrophe’s (which are 0x0027) and “en dash” which is 0x1320 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.
  • 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:
  • 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:

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.

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


Share this item with your network: