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

Answer Posted / rookie

if u are referring to duplicates...than

//SORTXSUM DD DSN=....
//SYSIN DD *
SORT FILEDS=COPY,
SUM FIELDS=NONE,XSUM

Is This Answer Correct ?    31 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use DISP=SHR in output file in JCL

957


A dd statement consists of 4 fields. Name them?

936


what is DSN parameter and DISP parameter is used for?

683


What is the purpose of dd * statement in jcl?

814


Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?

2225






Mention the types of job control statements?

692


what are the statements that are not valid to be included in an include statement?

778


How can the submitting users racf authority be overridden in a job stream?

758


When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

942


I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK

1487


How do you submit a job for execution?

640


if the submitter of a job wants to inform another user about the job completion, how can it be done?

760


how would you create a temporary dataset? And where will you use them?

772


What is job control language?

613


what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?

659