IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

EBCDIC File from Windows to Mainframe


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mrgnndhmk

New User


Joined: 01 Feb 2006
Posts: 51
Location: India

PostPosted: Wed Feb 10, 2010 5:28 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Feb 10, 2010 6:16 pm
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: 51
Location: India

PostPosted: Wed Feb 10, 2010 6:48 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed Feb 10, 2010 7:18 pm
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
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

Moderator Emeritus


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

PostPosted: Thu Feb 11, 2010 2:30 am
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: 51
Location: India

PostPosted: Thu Feb 11, 2010 2:45 am
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Feb 11, 2010 3:31 am
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

Moderator Emeritus


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

PostPosted: Thu Feb 11, 2010 3:31 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top