Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
FTP a tab delimited file

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

New User


Joined: 30 Sep 2006
Posts: 60

PostPosted: Mon May 05, 2008 2:29 am    Post subject: FTP a tab delimited file
Reply with quote

I have a tab delimited file that I need to ftp for processing. The issue that I'm facing is that the ftp is causing the data in the entire file to be put as a single record in the sequential file - the line breaks are not coming into effect when I ftp the file.

The end of the line value in the ftp'd file is x'0D' but the data is one single continuous record and not getting split into multiple lines.

Is there a way around this?

Aneesh.
Back to top
View user's profile Send private message

superk

Moderator Team Head


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

PostPosted: Mon May 05, 2008 3:03 am    Post subject: Reply to: FTP a tab delimited file to mainframe
Reply with quote

From the topic on the LOCSITE sub-command from the z/OS V1R9.0 Comm Svr: IP User's Guide and Commands manual:

Quote:

SBSENDEOL
Specifies which end-of-line sequence to use when ENCODING is SBCS, the data transfer type is ASCII, and data is being sent to the server. The following are possible values:

CRLF
Append both carriage return (X'0D') and line feed (X'0A') end-of-line sequences to each line of translated text. This is the default and the standard sequence defined by RFC 959. The z/OS server can receive ASCII data in this format only.

CR
Append only a carriage return (X'0D') end-of-line sequence to each line of translated text.

LF
Append only a line feed (X'0A') end-of-line sequence to each line of translated text.

NONE
Do not append an end-of-line sequence to the line of translated text.

Tip: The srestart subcommand is disabled if you configure a SBSENDEOL value other than CRLF.

Rules:


Most servers support only the CRLF value for incoming ASCII data. Do not specify another value for SBSENDEOL unless you have verified that the server is expecting the end-of-line sequence that you specify.

Do not use an end-of-line sequence other than CRLF if the server is a z/OS FTP server. The z/OS FTP server supports only the CRLF value for incoming data.

If you send a file to a server while SBSENDEOL has a value other than CRLF, a subsequent SIZE command to that server targeting the file you sent could yield unpredictable results. Any size indicated in the server reply for such a file might not be reliable.


To summarize, to receive a file in ASCII format, the file MUST contain a CRLF pair. If there's absolutely no way to get around this, then all you can do is transmit the file in BINARY mode, then translate it to EBCDIC using rules YOU specify.
Back to top
View user's profile Send private message
Aneesh

New User


Joined: 30 Sep 2006
Posts: 60

PostPosted: Mon May 05, 2008 6:21 am    Post subject: Reply to: FTP a tab delimited file
Reply with quote

Thanks a lot.
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 Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us