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
- 7520 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we use DISP=SHR in output file in JCL
How can the disposition of sysout datasets be set for an entire jobstream?
How jcl is used for testing batch programs?
when can a job time-out occur? How to overcome that?
1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat
Explain the function of dd name parameter with a 2 part structure; audit.report?
What do you understand by the term job time – out and how can you overcome that?
Define concatenating?
what is use of dcb parameter in dd statement?
Is condition checking possible in jcl?
what is a jcl?
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
What do you understand by jcl?
Differentiate between the joblib and the steplib statements?
Can I share my data with other jobs? How?
