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 Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm


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