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

Mainframe to linux file count mismatch


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

New User


Joined: 13 Mar 2014
Posts: 28
Location: USA

PostPosted: Thu Jun 13, 2019 9:49 pm
Reply with quote

Sent a file from mainframe to linux. Linux file count exceeds mainframe file count by 13. Exported the same mainframe flatfile to excel sheet via ftp, excel sheet number of rows exceeds by 40 as compared to mainframe file. What could be the reason?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Moderator


Joined: 14 Mar 2007
Posts: 10712
Location: italy

PostPosted: Thu Jun 13, 2019 10:20 pm
Reply with quote

probably you are sending as text a dataset that contains binary data
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 924
Location: Maryland

PostPosted: Thu Jun 13, 2019 10:23 pm
Reply with quote

shreya19 wrote:
Sent a file from mainframe to linux. Linux file count exceeds mainframe file count by 13. Exported the same mainframe flatfile to excel sheet via ftp, excel sheet number of rows exceeds by 40 as compared to mainframe file. What could be the reason?


Without any details on your particular case please do not expect to receive any meaningful advice.

So far the only possible answer is:

1) find where the problem is coming from?
2) fix this problem
3) run the fixed version of your job/script/whatever
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 747
Location: Pennsylvania

PostPosted: Thu Jun 13, 2019 10:56 pm
Reply with quote

I concur with Enrico.

What we have experienced is that when selected 'hex' data is converted from Ebcdic to Ascii, the character is changed to a carriage return or line feed.

This makes one line into two.

Do this a few times and you have 40 extra records.

What we had to do was convert packed decimal data to numeric before transmission.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 696
Location: Whitby, ON, Canada

PostPosted: Sun Jun 16, 2019 5:19 am
Reply with quote

daveporcelan wrote:
I concur with Enrico.

.....

What we had to do was convert packed decimal data to numeric before transmission.

We sometimes call this “converting the file to baby talk”. icon_biggrin.gif
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 Converting a file from PD to display ... SYNCSORT 4
No new posts Record count of RECFM=U tape file DFSORT/ICETOOL 17
This topic is locked: you cannot edit posts or make replies. Write Character to Hexadecimal file w... COBOL Programming 8
No new posts Looking for mainframe system programmers Mainframe Jobs 0
No new posts Checking the total counts inside a re... JCL & VSAM 5
Search our Forums:

Back to Top