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
- 13578 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / arthi
JOINKEYS F1=FILE1,FIELDS=(1,10,A)
JOINKEYS F2=FILE2,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=MATCHED,INCLUDE=(22,1,CH,EQ,C'B')
OUTFIL FNAMES=UNMATCHED,INCLUDE=(22,1,CH,EQ,C'N')
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
what are the statements that are not valid to be included in an include statement?
Are there any set of rules for the names of the steps used in a job? What are they?
I need exexution process for JCL programs
which utility is used a dummy utility?
What is concatenating?
What is the function of dd name parameter with a 2 part structure; audit.report?
what are the various stages of job processing?
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
If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?
What is the use of symbol // in jcl?
Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE
Brief description of inline procedure of jcl.
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?
what is “Cond= even” and “Cond=only”?
