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: 34
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
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

Senior Member


Joined: 29 Apr 2008
Posts: 2010
Location: USA

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: 792
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: 765
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts To get the count of rows for every 1 ... DB2 3
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top