MVSFORUMS.com

[shakkia]

Hello,

I need help with this. I tried few things myself and searched many topics in this forum.

I have a ascii(.DAT) text file, created by a third party vendor. I need to FTP this to mainframe. In FTP'ing from a server to the mainframe, the end-of-line characters ( \10 \13 ) are dropped, rather than converting to an EBCDIC end-of-line. A file with normal end-of-line behavior on the windows server, appears as one very long line on the mainframe.

Apart from notepad, if I open this ASCII file using other editors, records are perfectly displayed. But notepad doesn't seem to do so. It is similar with mainframe. If I open this with wordpad and save it as Non-DOS format file before FTP-ing, ftp results are perfect.

Questions
1. Is there a way to write a BAT code to say open with wordpad and save it as .TXT file?

2. I have declared a PS, with large blocksize(32,750) and recfm = U, into which data is FTPed without truncation. The ascii end-of-line in the dataset is represented as x'25'. Can I use sort utility to split this single record into multiple records by taking x'25' as a delimitter ? If yes, how.
This file in the current format cannot be opened in edit/view mode.

The file in mainframe looks like
------------------------------------------------------------------------------
88,015,0,,Z/.88,040,0,,Z/.88,045,0,,Z/.88,072,0,,Z/.88,074,0,,Z/.88,100,0,0,Z/.8
FF6FFF6F66E62FF6FFF6F66E62FF6FFF6F66E62FF6FFF6F66E62FF6FFF6F66E62FF6FFF6F6F6E62F
88B015B0BB91588B040B0BB91588B045B0BB91588B072B0BB91588B074B0BB91588B100B0B0B9158
------------------------------------------------------------------------------

Thanks
Shakkina
_________________
SBA

[dbzTHEdinosauer]

1. Notepad - there is an option (from the menu) that allows you to toggle from/to a view that provides end-of-line and a view that is one big line. More sophisticated 'word - processing' applications will break the line based on margines. Either view the txt file with a sophisticated field/codes display option or look at a hex image - if you want to see what the file contains.

2. When you FTP to the mainframe, you have options to add the CR/LF (0a0d); the FTP process will insert these characters as well as performing the ASC to EBC conversion.

3. Where, by the way, are the X'25's?
_________________
Dick Brenholtz
American living in Varel, Germany

[advoss]

I thought it was supposed to be \13\10
_________________
Alan Voss

[dbzTHEdinosauer]

that's why i always say CRLF - i never remember if it is 1310 or 1013 -
_________________
Dick Brenholtz
American living in Varel, Germany

[vak255]

Try this.. download Ultraedit from www.ultraedit.com.

You can try trial version first to see whether it solves ure purpose.

[semigeezer]

Can you please post the Hex version of the 1st 80 bytes or so from the PC, (upload in binary, cut from ISPF HEX mode and use [code] and [/code] tags)?

[shakkia]

Kiran,
Any editors apart from notepad including ultra edit works fine. Since I need to FTP the file through a scheduled batch job, I cannot open/edit the test file and save it as .TXT file before FTP. CUrrently if I do this and run a job, it works fine.

Dick,
The CRLF characters are present already. But when FTPed to mainframe it is not treated as a CRLF. Anyway I will try to check out options of adding it as an option during FTP. If you know it, could you please share it?

Alan,
I was not sure if it is /10/13 or /13/10. Thanks for correcting.

Shakkina

[shakkia]

semigeezer,

I FTPed the file in binary mode to a 80 byte predefined datatset. The hex mode is attached below. Honestly, I could not make much out of a binary mode. I hope this is what you asked for. I have mdofieid some sensitie data in TXT file before FTPing it.

Binary Mode - Hex format (Pos 1- 80)
X'25' is the CRLF in TXT file
[code:1:e90d7ab607] ------------------------------------------------------------------------------
...

[Nic Clouston]

I am not the brightest spark in the firework but here goes...
why are you uploading a non-binary file as binary?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

[semigeezer]

He isn't . I asked for the binary representation to verify that it was just the ASCII-EBCDIC translation that change the end of line to a x'25'.

The problem here is that the file has Unix end of line, not DOS. (cr instead of crlf) and FTP to MVS doesn't handle that well. The way around this is to either convert the file to DOS format using dos2unix (or a port thereof) or to first FTP the file to the Unix file system in USS, and then copy it over to the MVS file system. For example, the following Windows command file does this:

[Nic Clouston]

Shakkia wrote in the post immediately prior to mine:

[semigeezer]

2 posts before that is where I asked him to do that, just for purposes of posting it here.

[taltyman]

what about ftping it to a USS file on the mainframe?

[semigeezer]

Since no one is paying attention anyway, it must be time for a popular literary reference. With apologies to Charles Dickens...


THE PLUMP SISTER
Is it a horse?

FRED
No!

NIECE
Is it an ass?

At this, Fred roars with laughter; and is so inexpressibly tickled, that he
doubles over and stamps his foot.

FRED
No!

SEMIGEEZER SCROOGE
Is it a Unix file?

The Spirit gives Semigeezer Scrooge a look as if to say: "They can't hear you..." and
Semigeezer Scrooge scowls as if to say: "Shut up. I'm being a geek."

[shakkia]

Hi,

Sorry if I got you upset. I had few other stuff to completed and tried out your solution. Since I had never used BPXBATCH, I read a brief intro about it.

First let me admit, I didn't understand most of the commands. But I followed it to the T substituting user1 wiht my mainframe ID, password with my mainframe password, test.file with actualfilename.TXT. It gave erros saying PASS command failed, Login failed, JCL errored out in mainframe as it did not have steps. There was another error which said unable to write /u/userid/fileanme.TXT.

I could have gone worng in several places. I am trying out some options.
Would it be possible, time permitting to explain the options. I executed all the commands from the directory where the file to be ftped is located.

sorry...i could not take this lead further

Thanks a Ton
Shakkina
_________________
SBA