Interested to Buy Any Domain ? << Click Here >> for more details...
oza017.myorg.emp has 100 records ,oza018.myorg.staff has
200 records but 50 are the common records in both files
copy all the common records into oza017.myorg.xyz dataset
- 3 Answers
- 8972 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinodh
IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON
RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mariopuzo
//step01 exec pgm=sort
//sysin01 dd=input1,disp=shr
// dd=input2,disp=shr
//sysout dd=output1,disp=(new,catlg,del)
//sysin dd *
Sum fields=none
/*
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / challa srinivas
//SORT1 EXEC PGM=SORT
//SORTJNF1 DD DSN = oza018.myorg.staff
DSN = oza017.myorg.emp
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD DSN = oza017.myorg.xyz
JOINKEYS FILES=F1,
JOINKEYS FILES=F2,
REFORMAT FIELDS
SORT FIELDS=COPY
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the function of a dd statement?
What is GDG?
There are 2 steps in a JCL. If the first step abends due to system or user abend and the second step has COND specified as EVEN or ONLY, will this step still be executed inspite of the abend in the previous step?
i have 10 steps in my jcl. -->if i want to execute my program from 5th step what i have to do? don't give //* in ur previous steps --> if i want to execute my program from 1to 5 steps only what i have to do?
if we give two job cards in a single what happens
how you can access an uncataloged dataset in a JCL?
wht r s722,s822,s122 and s222 abends pls reply fast
How to print the Output to SPOOL using MSGCLASS and SYSOUT ?
How to execute step2,step1, step3 if step1,2,3 are in order
What is the function of the dd avgrec keyword in sms datasets?
how to solve u4038 abbend?........
How do you access an uncatalogued dataset in a jcl?
COBOL 
