FTP from windows server into Mainframe - Data truncation

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Our requirement is that we need to pull file from windows server. While doing this, we are getting error “Data was truncated” in FTP step.
We are using below sample FTP code to fulfill the requirements. Same below code is working fine when we pull file from UNIX server. Could you please confirm solution on how to do for windows? Please share if you have sample code

expat · Posted: Wed Jul 20, 2016 2:06 pm

Just way too much information missing from your post.

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Hi Expat, thanks for your reply!!
Could you please let me know what information you want based on that I will share. I thought I had shared all required information.

expat · Posted: Wed Jul 20, 2016 3:34 pm

What is the record format, length for both datasets.

I also recall using parameters to set RECFM, LRECL on the mainframe for received files.

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

We are receiving file with record length as 300 including CRLF(which I was not aware)from windows server.
We have already created dataset before FTP step with length as 300 and recfm as FB

expat · Posted: Wed Jul 20, 2016 3:49 pm

Hmmmmmmmmmmmmmmmm,

Doesn't windows have a default record length of 256 ?

I know that one of my guys had a whole heap of problems reading in a file longer than 256 - until he specified a much longer LRECL

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Thanks for your reply..
No, We have requirement to keep 300 length to receive data from windows server. Is there any solution for this

Rohit Umarjikar · Posted: Wed Jul 20, 2016 4:02 pm

SITE/LOCSITE

expat · Posted: Wed Jul 20, 2016 4:12 pm

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Thanks Rohit/Expat,

I was trying with below, still I am getting data truncation error. Please help with sample code

expat · Posted: Wed Jul 20, 2016 6:22 pm

I would guess that you are running the ftp process from the mainframe.

The possible problematic default length exists on windows.
What have you done to address this at the windows end.
i.e. telling the process to use your record length at the windows end.

Robert Sample · Posted: Wed Jul 20, 2016 6:25 pm

The FTP code you are executing is perfectly acceptable. Your problem is NOT with FTP -- your problem is a data problem. Asking for sample code will NOT in any way help you, even if you got it.

Is the data being transferred from a Unix machine to a Windows machine before going to the mainframe? If so, I would guess that Unix line terminators are being used instead of Windows line terminators. Or, the data might not be in ASCII but a different code page (or even UTF-8).

Your easiest -- and best -- way to fix this is to stop asking questions on this forum, create a data set with 600 LRECL (since your original post said 600 bytes were transferred), FTP your data into this data set, and use TSO/ISPF edit to look at the data in hexadecimal. This should tell you if your line terminator is Unix or not. If you still have troubles with it after doing this, you can post (using the Code tag) your data in hex format so we can look at it and probably see the issue.

steve-myers · Posted: Wed Jul 20, 2016 8:06 pm

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Hi Robert,

Thanks for your valuable information. Initially the file is created in Linux server and moved to windows server. from there, mainframe FTP job is trying to pick the file.

Already we have tried with LRECL as 600 and data was written without truncate. We put hex on, and found that X'25' in end of each line. Please help us.

steve-myers · Posted: Wed Jul 20, 2016 10:36 pm

Robert Sample · Posted: Wed Jul 20, 2016 11:52 pm

Have you tried SBSENDEOL? If not, try this:

Rohit Umarjikar · Posted: Thu Jul 21, 2016 12:14 am

PSPad

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Thanks all for your support.

Still the issue is reported. I have followed the above mentioned solution.

Server IP address
username
password
ASCII
LOCSITE SBSENDEOL=LF
CD UAT\outgoing
GET filename.dat 'xxxx.yyyy.zzzz ' (REPLACE
QUIT

QUOTE is not working in mainframe side.

Nic Clouston · Posted: Thu Jul 21, 2016 3:00 pm

You are still not using the code tags. Why should I not lock the topic?

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

The error is saying that 'Data was truncated'.
additionally QUOTE LOCSITE SBSENDEOL=LF is not worked. so I removed the QUOTE and below error is not coming

Robert Sample · Posted: Thu Jul 21, 2016 5:10 pm

You need to talk to your site support group and get their assistance. If you cannot do this or they cannot help you, your choices are to FTP from the Unix machine to z/OS, or to give up on FTP and find a different way to transfer the data.

Garry Carroll · Posted: Thu Jul 21, 2016 5:48 pm

Robert Sample · Posted: Thu Jul 21, 2016 6:19 pm

I did NOT say that QUOTE LOCSITE SBSENDEOL=LF would fix your problem; I asked if you had tried it since it can fix some line terminator issues. Since you won't post any data for us to look at, and you keep saying things "don't work" -- which is a TOTALLY USELESS phrase since it doesn't provide any information about the problem -- I see no reason to continue attempting to help. You would benefit from finding the IP User's Guide manual in the Communications Server bookshelf for your release of z/OS and reading up on FTP along with its sub-commands and options.

I don't provide extraneous information in my code, generally. If I write QUOTE LOCSITE ... then I mean QUOTE LOCSITE ... and leaving off the QUOTE, as you did, does not really make sense.

Contact your site support group. Or, FTP directly from the Unix machine to the z/OS machine so the line terminator issue becomes moot. Or, realize that FTP won't do what you want from the Windows machine and use a different method (depending upon your site, you could have a number of options -- but only your site support group can tell you for sure) to transfer the data.

sathyajes · New User Joined: 02 Mar 2006 Posts: 35 Location: Chennai

Hi Robert and Rest
Thanks lot for your help. it's helped me a lot.

Rohit Umarjikar · Posted: Thu Jul 21, 2016 9:01 pm

Please post us back the resolution you will have ,so that others in the same situation can be benefited.