Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Wrete a JCL to compare two files and mached records move to
onc file & un mached rows wants to another file?

Answer Posted / sachin borase

//JOBNAME
//S1 EXEC PGM=SORT
//SORTNJF1 DD DSN=FILE1
//SORTNJF2 DD DSN=FILE2
//SORTOUT DD DSN=O/P1
//SORTOF1 DD DSN =O/P2
//SYSIN DD *
JOIN KEYS = 01,FIELDS=(1,10,CH)
JOIN KEYS = 02,FIELDS=(1,11,CH)
REFORMAT FIELDS = (F1:1,80,F2:1,80)
SORT FIELDS = COPY
JOIN UNPAIRED,F1,F2

/*
IF YOU WANT EXACT SYSNTAX THEN TELL ME I WILL PROVIDE YOU.

Is This Answer Correct ?    62 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?

1235


I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?

1313


what is a jcl?

1086


Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You

2734


What are the parameter we cannot use in procedure? How many instream we can write in single jcl?

1000


What does a disposition of (new,catlg,keep) for a dsn mean?

1070


Explain the function of dd name parameter with a 2 part structure; audit.report?

1398


Why block size is multiple of lrecl in jcl?

1354


In job processing, what happens in execution stage?

1136


Mention the types of job control statements?

1124


Explain the purpose of the dd keylen parameter?

1099


What are the 4 fields in dd statement?

1190


How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you

1015


What is multithreading in jcl?

1397


What is catelog procedure and how many catelog procedure to use in one job?

8551