can we compare two GDGs files and output duplicates in third dataset using file aid based on few key fileds in a proc.can anyone post a sample jcl if possible
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
Saujanya,
Quote:
can we compare two GDGs files
Do you mean gdg versions. If you meant versions, it just like normal flat file comparisions. Either your provide absolute generation number or provide generation number (like (0)/(-1) in the JCL).
yes murali they are gdg versions and actually we are removing comparex utility ,so iam looking for other options .i came to know file-aid is also a better option to do the same.but how i can use fileaid in proc as i have to compare them write duplicates in another gdg based on few key fields and subsequently that file will be used for reports.can you give me sample jcl for the same
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
saujanya,
As of now, I have no mainframe access. But can provide a rough way to get the required JCL.
In the fileaid, there is an option called COMPARE (either in mainscreen or in the utilities option - cant remember exactly). Once you enter into compare screen, give the file names to compare and bottom of the screen select for BATCH MODE. Use the JCL after providing job card (if not given earlier) in the next screen.
hi murli the gdgs which iam using are temporary so i cant give record format in compare option in file-aid but i got sample jcl from other link.one more query iam using a control card in comaprex so how to use it here.
KEY=(1,2,C,A)
KEY=(3,4,C,A)
KEY=(7,16,C,A)
KEY=(23,16,C,A)
KEY=(39,15,C,A)
KEY=(54,6,C,A)
KEY=(60,7,C,A)
KEY=(81,1,C,A)
MASK=(61,19)
MASK=(82,END)
MAXDIFF=5
CONTINUE
PRINT=MISMATCH
COPYDIFF
and or can i use the same control card.can you please suggest.
hi murli you know my problem so can you please suggest or tell me how to do it in superc by using ISRSUPC instead of FILEAID.this is the sample jcl i got .