Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Data was truncated while FTP'ing?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Siriporn P.

New User


Joined: 16 Jan 2006
Posts: 9

PostPosted: Tue Jun 06, 2006 1:42 pm    Post subject: Data was truncated while FTP'ing?
Reply with quote

Hi,

I found out why data was being truncated and the reason was because my file is a very big line with data. Is there an option in FTP where I can specify that I want data to be cut every 200 bytes and write lots of lines instead of only one?

FYI. I was uploading using FTP script, not using option 6 as it was very slow since the host i connected to is very far away (Houston) while i am here in Bangkok.

Thanks,
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue Jun 06, 2006 7:34 pm    Post subject: Re: Data was truncated while FTP'ing?
Reply with quote

No, not that I've seen documented.

I see that you have two options here:

1. Re-format the data to your required specifications on the server before invoking the FTP process to the mainframe.

2. FTP the data to a dataset allocated as RECFM=FB LRECL=200 in binary (image) mode. The ASCII data should wrap into the 200-byte records. Then, you'll need to write a program to un-wrap the records as required and translate them from ASCII back into EBCDIC.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm
No new posts JCL to get submitted once dataset has... vinu78 JCL & VSAM 17 Thu Feb 16, 2017 7:32 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us