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
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 |
can u execute a proc from another proc?
In one of intervie, my interviwer asked, I have a file which contains 4 records I would like to split the 4 different outputs for each record how to do?
14 Answers Cap Gemini, Cognizant, JPMorgan Chase, TCS, Xansa,
which utility is used a dummy utility?
Explain about User Information
How many steps we can overide in the proc's?
Is CPU time (TIME parameter) assigned to a JOB and JOBSTEP BOTH, by default ?
What are the causes for S0C1, S0C4, S0C5, S0C7, S0CB abends ?
what is fixed length and variable length and difference between them
What do you know about jcl?
Describe the various parameters utilized in the creation of a gdg?
what is the alternative to model parameter?
Describe the DD statement, its meaning, syntax and keywords?