Sort problem



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Sort problem

Postby mindhawk » Tue Feb 09, 2010 8:04 pm

Hi

I am trying to run a comparison between 2 files.
Read in both and the match on an account ID.
If file A acct id < file B acct id . read file A
and reverse for file B

my problem is that on one file I have file A acct ABRAHAM168
other file B acct is ABRAHA1070

The hex for the first 6 chars are the same but the hex for the last 4 are higher on file B (f1 f0 f7 f0) as opposed to D4 F1 F6 F8
File B does have the account ID I am looking for on File A (ABRAHAM168) but it is after ABRAHA1070.

How can I sort file A so to match the sort in file B ?
I dont want to sort FILE B as its 200Gig split into 65 files.

Any assistance appreciated !
mindhawk
 
Posts: 1
Joined: Tue Feb 09, 2010 7:57 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort problem

Postby Frank Yaeger » Tue Feb 09, 2010 10:16 pm

Your description is very confusing.

CH format (EBCDIC) sorts the letters before the numbers.

AC format (ASCII) sorts the numbers before the letters.

You just have to be sure that both files are sorted using the same format.

If you want more specific help, show an example of the records in each input file so I can see how they are ordered.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post