IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

comparing 2 files by file-aid & output out of sync recor


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
saujanya_2831

New User


Joined: 09 May 2007
Posts: 27
Location: pune

PostPosted: Wed Jun 13, 2007 3:39 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jun 20, 2007 4:30 am
Reply with quote

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
View user's profile Send private message
student_mf

New User


Joined: 15 Jun 2007
Posts: 23
Location: pune

PostPosted: Thu Jun 21, 2007 3:43 pm
Reply with quote

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
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Thu Jun 21, 2007 4:07 pm
Reply with quote

student_mf,

Read the forum rules before you post anything in the forums.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jun 21, 2007 6:08 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Jun 21, 2007 8:11 pm
Reply with quote

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
View user's profile Send private message
student_mf

New User


Joined: 15 Jun 2007
Posts: 23
Location: pune

PostPosted: Fri Jun 22, 2007 12:23 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top