Solved

FTP Will strip all trailing blanks, Why?

Posted on 2001-08-27
7
2,181 Views
Last Modified: 2008-03-04
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
Comment
Question by:theo kouwenhoven
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Expert Comment

by:samic400
Comment Utility
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
 
LVL 16

Author Comment

by:theo kouwenhoven
Comment Utility
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
 
LVL 13

Expert Comment

by:samic400
Comment Utility
I'm sorry. I should have read your original question better - 400 to pc not assuming pc to 400.
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 3

Accepted Solution

by:
P_S_Price earned 100 total points
Comment Utility
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
 
LVL 16

Author Comment

by:theo kouwenhoven
Comment Utility
Thanx a lot,P_S_Price !!!
It worx
0
 
LVL 16

Author Comment

by:theo kouwenhoven
Comment Utility
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
 
LVL 3

Expert Comment

by:P_S_Price
Comment Utility
Ask IBM!!!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now