what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file
Answer Posted / vinodh
Refining the above sort card statement after executing it
SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCH,INCLUDE=(22,1,CH,EQ,C' ')
OUTFIL FNAMES=UNMATCH,INCLUDE=(22,1,CH,EQ,C'N')
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain how can a stopped job be started again?
Explain the purpose of the dd keylen parameter?
Matching Logic in Jcl not in cobol.Could any one please answer this question
Explain about ISPF/TSO Commands
Which statement is used to identify the private libraries in job?
What is the purpose of dd dummy statement?
Describe the various parameters utilized in the creation of a gdg?
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
What is the purpose of dd * statement in jcl?
What is the syntax of JCL statement?
Explain how can an in-stream dataset be terminated?
Must tape dataset definitions include vol=ser specifications?
what sort card you will use to copy the data from one dataset to another dataset?
What is the purpose of dd?
Can I share my data with other jobs? How?