File truncation using FTP to SQL

bansal · New User Joined: 03 Jan 2007 Posts: 27 Location: Hyderabad

I am FTPing a file which of 80 bytes to SQL. That file contains 45 bytes of data and rest are spaces(fillers). When SQL guys recieve that file, it is of 45 bytes only. Can anyone please help in this regards?

superk · Posted: Fri May 18, 2007 5:51 pm

First of all, if the FTP server site is using the Windows OS, then what you are seeing is normal. There is a setting to override this.

What level of z/OS are you running so I can post the appropriate manual link?

bansal · New User Joined: 03 Jan 2007 Posts: 27 Location: Hyderabad

Hi Superk,

Thanks for your quick reply.

I am using this config

ISPF_--------ISPF FOR Z/os 01.06.00
OS Name .---Z/OS
OS version ----------------01.06.01
and level

JES2 ---------JES2 z/os 1.5

But Superk, our target system uses Windows OS only, So can u plz tell what override options are there? Due to which that file is getting truncated..

I am doing this FTP in TEST region. But in PROD region, i am using INFOMOVE or NDM, So i am not sure whether the file will truncate in those cases also.

Thanks for your help..

superk · Posted: Fri May 18, 2007 8:24 pm

You'll want to set the TRAILingblanks option of the LOCSIte command as described here in the section 5.34 LOCSIte subcommand--Specify site information to the local host of the z/OS V1R6.0 CS: IP User's Guide and Commands.

Of course, the setting can always be permanently set in the Use [URL] BBCode for External Links (SYSFTPD) dataset as described in the manual.