View previous topic :: View next topic
|
Author |
Message |
ratnakumar
New User
Joined: 07 May 2009 Posts: 30 Location: Banglore
|
|
|
|
Hello,
I have requirement to check whether the list of card numbers are present in a file or not..
say, File1 has the below data, Where first 5 characters represents Card number.
00001ABCDE
00012ACDSE
00014AAAER
00014ZSDFA
00009AZSDF
00019AATEW
00006AEWER
00011AMMPP
So Output should look like:
00001 RECORD FOUND
00002 RECORD NOT FOUND
.
.
.
.
00019 RECORD FOUND
Can anyone please help me doing it with sort.[/code] |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Ah - by sort - not by JCL as thtile infers. Just as well because JCL cannot do it. Neither can anything else - given your input everything is either found or not found as you have not provided anything to compare against! Also, LRECL and RECFM, possibility of duplicates etc, would be useful once we know all the data specifications.
If you have a list to compare against then start looking and experimenting with JOINKEYS. |
|
Back to top |
|
|
ratnakumar
New User
Joined: 07 May 2009 Posts: 30 Location: Banglore
|
|
|
|
My bad,.. I should have mentioned it as SORT in the subject line...
File 1 has LRECL 231 (VB)
File 2 has LRECL 5 (VB)
And File1 being a daily data file, it may have duplicate records. File 2 has unique cardnumbers. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
JOINKEYS, SUM FIEDLS=NONE on your file with duplicates. If you need it back in the original order, you'll have to SORT in the Main Task. Lots of examples here. |
|
Back to top |
|
|
|