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
 

 

EBCDIC File from Windows to Mainframe

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

New User


Joined: 01 Feb 2006
Posts: 46
Location: India

PostPosted: Wed Feb 10, 2010 5:28 pm    Post subject: EBCDIC File from Windows to Mainframe
Reply with quote

Hi All,

I have couple of EBCDIC format files in Windows. The task is to take those files to Mainframe and dump the file displaying each field of the record.

The simple way I know is FTP the file to Mainframe in binary mode so that in Mainframe we I can see it as readable format.

The problem I am facing is I am loosing the COMP-3/COMP variables and the format in the file is lost even though I give the exact record length (the files are fixed record length).

I have attached the format that is displayed.

Please let me know if there is any tool/ways to do this conversion in a systematic way.

Regards,
Muruganandham k
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Wed Feb 10, 2010 6:16 pm    Post subject:
Reply with quote

Have you allocated the file on the mainframe and then transferred it via FTP? Or you can use QUOTE SITE to provide the LRECL and RECFM for the file as part of your FTP commands.

Transferring a file in binary will not change the COMP or COMP-3 values.
Back to top
View user's profile Send private message
mrgnndhmk

New User


Joined: 01 Feb 2006
Posts: 46
Location: India

PostPosted: Wed Feb 10, 2010 6:48 pm    Post subject:
Reply with quote

For VB file it is more even worse in the format. How should I transfer a VB file which is in EBCDIC format?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Wed Feb 10, 2010 7:18 pm    Post subject:
Reply with quote

Quote:
I give the exact record length (the files are fixed record length).
Fixed length records in EBCDIC on a PC are easy to transfer. The problem with variable blocked files is that when transferred to the PC, unless special effort is taken, the BDW and RDW fields are not transferred since they are not considered part of the data record. If they were not transferred, it is not possible to transfer an EBCDIC VB file back to a mainframe and recover the original records since the record lengths are no longer available.
Back to top
View user's profile Send private message
akhi007

New User


Joined: 30 Jan 2006
Posts: 35
Location: Richmond

PostPosted: Thu Feb 11, 2010 2:18 am    Post subject:
Reply with quote

Can you help me understand what is the special effort to resolve this issue... Thanks in advance
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Feb 11, 2010 2:30 am    Post subject:
Reply with quote

Hello,

Suggest the file from the PC be formatted differently when it is created.
Back to top
View user's profile Send private message
mrgnndhmk

New User


Joined: 01 Feb 2006
Posts: 46
Location: India

PostPosted: Thu Feb 11, 2010 2:45 am    Post subject:
Reply with quote

Hi,

Thanks for the inputs. I have suggested to take care of VB file creation.

Any idea why the format of fixed length is also disturbed as in the image attached in the first post?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7993
Location: Bellevue, IA

PostPosted: Thu Feb 11, 2010 3:31 am    Post subject:
Reply with quote

What's the hex value for the non-display character (the period) at the start of each line you posted?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Feb 11, 2010 3:31 am    Post subject:
Reply with quote

Hello,

I suspect this is due to the lrecl on the mainframe being slightly different than the actual data length (including any cr/lf characters) in the uploaded file.
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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 1 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 3 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts FTP from Mainframe to Unix - with CRLF vasanthz All Other Mainframe Topics 5 Thu Mar 23, 2017 5:12 am
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm


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