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: 32
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: 10803
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
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1228

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: 769
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: 711
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 To re-format the file using SORT card DFSORT/ICETOOL 6
No new posts Read file names from existing file th... DFSORT/ICETOOL 6
No new posts File Status Error code 39 when Proces... COBOL Programming 2
No new posts Convert PS to TXT file using jcl JCL & VSAM 7
This topic is locked: you cannot edit posts or make replies. Sort to include records of file 2 int... Java & MQSeries 1
Search our Forums:

Back to Top