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

Difference of records in output file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Fri Jun 02, 2006 6:50 pm
Reply with quote

Hi

Here is my requirement can i know the sort job for it.......

file1
11111111111111111
22222222222222222
22222222222222222
33333333333333333
44444444444444444

Infile2 contain

11111111111111111
33333333333333333
555555555555555555
555555555555555555

The sort output should be

222222222222222222
222222222222222222
444444444444444444
5555555555555555555
5555555555555555555

The file is variable lenght file.. max lrecl is 200...

Thanks in advance

Regards
jai
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Jun 02, 2006 8:56 pm
Reply with quote

So you want the output file to contain the records found in one input file but not in the other input file - right?

What are you comparing on - the entire record (up to 200 bytes) or the first n bytes (what is n) or what?

Is the length of the 1's record 17? If not, what is its length?

Is the length of the 5's record 18? If not, what is its length?
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Fri Jun 02, 2006 9:04 pm
Reply with quote

Yes frank,

I want to compare the whole record of 200 bytes.....

Regards
jai
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Jun 02, 2006 10:07 pm
Reply with quote

Please answer my other questions.
Back to top
View user's profile Send private message
bcmohanty

New User


Joined: 17 May 2006
Posts: 17

PostPosted: Mon Jun 05, 2006 1:56 pm
Reply with quote

u can write a small file balancing program (B LINE logic)....it will be the easyest way to do.....before using the files (ie.the two files used as input to program) it should be shorted.....
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top