Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
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    Post subject: comparing 2 files by file-aid & output out of sync recor
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

Site Director


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

PostPosted: Wed Jun 20, 2007 4:30 am    Post subject:
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    Post subject: getting empty file
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: 1439
Location: Bangalore,India

PostPosted: Thu Jun 21, 2007 4:07 pm    Post subject:
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

Site Director


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

PostPosted: Thu Jun 21, 2007 6:08 pm    Post subject:
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

Senior Member


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

PostPosted: Thu Jun 21, 2007 8:11 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us