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: 10639
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: 635
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: 726
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: 684
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 Sharepoint to mainframe indransec DB2 4 Tue Dec 10, 2019 1:54 pm
No new posts File transfer issue with end of line ... VINAY PALLELA TSO/ISPF 4 Thu Nov 14, 2019 12:01 am
No new posts Count From Multiple Inputs Tyler Dunbar DFSORT/ICETOOL 5 Tue Nov 12, 2019 1:07 am
No new posts File compare, where file has header a... VINAY PALLELA SYNCSORT 8 Thu Nov 07, 2019 5:05 pm
No new posts Enabling Crosshair cursor in mainframe priya_t23 TSO/ISPF 2 Wed Nov 06, 2019 11:29 am

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