|
View previous topic :: View next topic
|
| Author |
Message |
saujanya_2831
New User
Joined: 09 May 2007
Posts: 27
Location: pune
|
|
|
|
| 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 |
|
| Back to top |
|
 |
murmohk1
Senior Member
.jpg)
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). |
|
| Back to top |
|
|
saujanya_2831
New User
Joined: 09 May 2007
Posts: 27
Location: pune
|
|
|
|
| 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 |
|
| Back to top |
|
|
murmohk1
Senior Member
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.
Hope this helps you out. |
|
| Back to top |
|
|
saujanya_2831
New User
Joined: 09 May 2007
Posts: 27
Location: pune
|
|
|
|
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. |
|
| Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
| I dont know comparex. But you cannot use this for fileaid. |
|
| Back to top |
|
|
saujanya_2831
New User
Joined: 09 May 2007
Posts: 27
Location: pune
|
|
|
|
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 .
// JOB
//SEARCH EXEC PGM=ISRSUPC,PARM=(’SRCHCMP,ANYC’)
//STEPLIB DD DSN=ISPF330.LOAD,DISP=SHR
//NEWDD DD DSN=USERID.PDS,DISP=SHR
// DD DSN=USERID.PDS2,DISP=SHR
//OUTDD DD SYSOUT=*
//SYSIN DD * SRCHFOR ’NEEDLE’,W,10:20
/*
//
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
thnx |
|
| Back to top |
|
|
saujanya_2831
New User
Joined: 09 May 2007
Posts: 27
Location: pune
|
|
|
|
| Hi murli can i get the same result in file-aid. |
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
