Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2742
  • Last Modified:

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??
0
theo kouwenhoven
Asked:
theo kouwenhoven
  • 3
  • 2
  • 2
1 Solution
 
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
 
theo kouwenhovenAuthor 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
 
samic400Commented:
I'm sorry. I should have read your original question better - 400 to pc not assuming pc to 400.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
P_S_PriceCommented:
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
 
theo kouwenhovenAuthor Commented:
Thanx a lot,P_S_Price !!!
It worx
0
 
theo kouwenhovenAuthor 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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now