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 |
How are GDGs concatenated?
what are the statements that are not valid to be included in an include statement?
How do you create a temporary dataset? Where will you use them?
WORKING-STORAGE SECTION. 1 GROUP-ITEM. 05 AMOUNT-1 PIC 99V9 USAGE COMP VALUE 50. 05 AMOUNT-2 PIC 9(4)V99 USAGE COMP. PROCEDURE DIVISION. MOVE ZERO TO GROUP-ITEM. ADD 50 TO AMOUNT-1. DISPLAY AMOUNT-1. STOP RUN.
When will we need to specify Space parameter ?
jcl is like a complier....?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
can u explain gdg with example wht happens if we give limit,empty,noempty,scartch and no scartch
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?
what's the significance of freespace(0 0) and freespace(100 100)
if we compile the cobol+ db2 program now ofter 5 years we need to compile again?
how GDGs are concatinated?