Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Mainframe to linux file count mismatch

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
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    Post subject: Mainframe to linux file count mismatch
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 Member


Joined: 14 Mar 2007
Posts: 10664
Location: italy

PostPosted: Thu Jun 13, 2019 10:20 pm    Post subject: Reply to: Mainframe to linux file count mismatch
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: 716
Location: Maryland

PostPosted: Thu Jun 13, 2019 10:23 pm    Post subject: Re: Mainframe to linux file count mismatch
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: 735
Location: Pennsylvania

PostPosted: Thu Jun 13, 2019 10:56 pm    Post subject:
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: 689
Location: Whitby, ON, Canada

PostPosted: Sun Jun 16, 2019 5:19 am    Post subject:
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    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 Add the name in the PS file and creat... dharmaraok DFSORT/ICETOOL 9 Wed Apr 01, 2020 10:43 am
No new posts DFSORT Output file order query A_programmers DFSORT/ICETOOL 1 Thu Mar 26, 2020 11:59 pm
No new posts Error Creating KSDS file, REASON CODE... sandeep prajapati JCL & VSAM 8 Tue Mar 24, 2020 12:05 pm
No new posts Need help on DB2 load in Mainframe subratarec DB2 5 Tue Mar 24, 2020 2:08 am
No new posts Issue while reading a file in browse ... sivasaras TSO/ISPF 7 Sun Mar 01, 2020 12:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us