Interested to Buy Any Domain ? << Click Here >> for more details...
what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file
- 3 Answers
- 13898 Views
- Virtusa, I also Faced
- E-Mail Answers
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
how do you access an uncataloged dataset in a jcl?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?
What are steplib and joblib?
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
Explain the function of //jcllib statement?
Is their any set of rules for dd? Explain.
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?
Are there any set of rules for the names of the steps used in a job?
which utility is used to sort a file in jcl?
How can the submitting users racf authority be overridden in a job stream?
What is the function of the dd avgrec keyword in sms datasets?
What are the parameter we cannot use in procedure?
Is automatic restart possible in jcl?
