View previous topic :: View next topic
|
Author |
Message |
saujanya_2831
New User
Joined: 09 May 2007 Posts: 27 Location: pune
|
|
|
|
hi ,
i need to compare 2 files and output out of sync records in third file (inserted or deletd) and i need to do it on batch .iam goin through the manual but iam not able to put the option in jcl .even iam trying to get jcl from file-aid itself but my files do not have a record layout .so any suggestions. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might consider running the batch FileAid to identify the matches and the out-of-sync records. Send that output to a dataset rather than sysout.
Then - Use your sort product to copy the mis-matches to another dataset. |
|
Back to top |
|
|
student_mf
New User
Joined: 15 Jun 2007 Posts: 23 Location: pune
|
|
|
|
when iam executing this iam getting empty file in output file
//FILEAID EXEC PGM=FILEAID
//SYSPRINT DD SYSOUT=*
//DD01 DD DSN=inputfile1,DISP=SHR
//DD02 DD DSN=inputfile2,DISP=SHR
//DD01O DD DSN=outputfile,DISP=(,CATLG,DELETE),
// SPACE=(CYL,(32,0),RLSE),
// DCB=(RECFM=FB,LRECL=90,BLKSIZE=27000)
//SYSIN DD *
COMPARE
/* |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
student_mf,
Read the forum rules before you post anything in the forums. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Murali - please clarify your response - thanks
s_m - please post the sysout data from when that jcl was submitted. It most likely has info that will point out what has happened. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
student_mf,
Please show the contents of inputfile1 & nputfile2 used in above JCL, show the SYSOUT data as well, as Dick suggested. We can come up with better solutions. |
|
Back to top |
|
|
student_mf
New User
Joined: 15 Jun 2007 Posts: 23 Location: pune
|
|
|
|
Hi i have used file-aid 10 option and generated batch jcl for comparision using sync/key and 1 to 1 but when i execute the job iam getting an empty file in both cases and sending the sysprint message also .please suggest and the input files contains records like below
0705300000000000 3052524370 00000000000080020190200005803 CM
0705300000000000 3052565309 00000000000450020120600060003 CM
0705300000000000 4134490030 00000000000530021461500315703 CM
0705300000000000 4148995929 00000000000400019335800094403 CM
and i got 6 nonmatching records when i checked thru superc.
//MP7JKEY JOB MSGCLASS=T,NOTIFY=serSSR
//FASTEP EXEC PGM=FILEAID,REGION=6M
//STEPLIB DD DISP=SHR,DSN=SYS1.FILEAID.LOAD
//SYSPRINT DD SYSOUT=T
//SYSLIST DD SYSOUT=T,DCB=(LRECL=183,BLKSIZE=1830)
//DD01 DD DSN=test.T1,
// DISP=SHR
//DD0C DD DSN=test.T2,
// DISP=SHR
//DD0CP DD DSN=FILEAID.CC.D07172.T080150,
// DISP=SHR
//DD01O DD DSN=output.FT1,DISP=(,CATLG),
// DCB=(RECFM=FB,LRECL=90,BLKSIZE=27000),
// SPACE=(27000,(15000,100),RLSE),UNIT=DISK
//SYSIN DD *
$$DD01 COMPARE
/*
//
sysout data
$$DD01 COMPARE
CONTROL CARD DOES NOT BEGIN WITH $$DD
.....SKIPPING TO NEXT $$DD CARD |
|
Back to top |
|
|
|