FTP Will strip all trailing blanks, Why?

Hi,

I have a PF where in some cases the last 2 fields (2x12 characters) are filled with blanks. During FTP from AS/400 to an ASCII machine, all the records are truncated after the last non blank character. So I'm missing the last two fields. This give some problems for the program that has to process the retrieved data.

How can I prevent this truncation without changing the contents of the resultfile??
Is there any EBCDIC character that will replaced during translation to ASCII by a blank, without stripping the trailing blanks??
LVL 17
MurpheyApplication ConsultantAsked:
Who is Participating?
 
P_S_PriceConnect With a Mentor Commented:
If You Read The AS/400 manual on TCP/IP confguration you will see in there (Chapter 7 I think) quite clearly that the AS/400 strips trailing Blanks from text files.

There are a couple of routes round this. One is to send the file in Binary mode as mentioned earlier, but initilly converting to ASCII, but a much tidier solution is to use the following sub command: -

LOCSIte Trim 0

0
 
samic400Commented:
Are you doing a bin first before doing a GET? A bin should do the trick if you are retrieving it from the AS400 to your PC.

Or try this.

FTP

then sign on

then type  -  QUOTE SITE TRIM 0 - this should stop the trimming.

Hope this helps!



0
 
MurpheyApplication ConsultantAuthor Commented:
Samic400,

Using BIN, command is not the solution, it wil stop to convert EBCDIC to ASCII.

The QUOTE option is not supported (I think), when I send the file from the AS400 to the PC the following message appears in the FTP-log file:
"202 Command not implemented, superfluous at this site."


0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
samic400Commented:
I'm sorry. I should have read your original question better - 400 to pc not assuming pc to 400.
0
 
MurpheyApplication ConsultantAuthor Commented:
Thanx a lot,P_S_Price !!!
It worx
0
 
MurpheyApplication ConsultantAuthor Commented:
Hey P_S_Price,

Can you tell me why this option is not listed in the FTP helpfunction.
Are there more fo this "Secret" options, where can I find them.

Regards
Murphey
0
 
P_S_PriceCommented:
Ask IBM!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.