Solved

FTP Will strip all trailing blanks, Why?

Posted on 2001-08-27
7
2,301 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
ID: 6429539
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
ID: 6431146
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
ID: 6431356
I'm sorry. I should have read your original question better - 400 to pc not assuming pc to 400.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 3

Accepted Solution

by:
P_S_Price earned 100 total points
ID: 6435511
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
ID: 6435593
Thanx a lot,P_S_Price !!!
It worx
0
 
LVL 16

Author Comment

by:theo kouwenhoven
ID: 6435598
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
ID: 6435670
Ask IBM!!!
0

Featured Post

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Jobs on iSeries autoanswer by itselfs. 10 167
Read spool files from iseries in C# 4 271
iSeries PERL Scripts 7 157
Webservice response iSeries 1 31
For months I had no idea how to 'discover' the IP address of the other end of a link (without asking someone who knows), and it drove me batty. Think about it. You can't use Cisco Discovery Protocol (CDP) because it's not implemented on the ASAs.…
This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

773 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