Interested to Buy Any Domain ? << Click Here >> for more details...
i have two flat files.i want to select one record from that
file by using jcl.for example file1 contains emp
no,name,joining date. file2 has same details.emp no is
primary key. i will give empno.that emp details send to
outfile.please let me know if any one knows it.give sample
code.
- 1 Answers
- 7268 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vs kumar
//SORTIN DD DSN=INPUTFILE1,DISP=SHR
//SORTOF01 DD DSN=X.Y.OUTFILE1,DISP=SHR
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=01,STARTREC=1,ENDREC=1
/*
//SORTIN DD DSN=INPUTFILE2,DISP=SHR
//SORTOF02 DD DSN=X.Y.OUTFILE2,DISP=SHR
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES=02,STARTREC=1,ENDREC=1
/*
//STEP2 EXEC PGM=SORT
//SORTIN DD DSN=X.Y.OUTFILE1,DISP=SHR
// DD DSN=X.Y.OUTFILE2,DISP=SHR
//SORTOUT DD DSN=X.Y.OUTFILE,DISP=SHR
//SYSIN DD *
SORT FIELDS=COPY
/*
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the purpose of dd?
List in order the hierarchical levels of jcl?
What statement marks the beginning of a job step; assigns a name to the step; identifies the program or catalogued or in-stream procedure to be executed in the step?
How do you access an uncatalogued dataset in a jcl?
What do you understand by jcl?
What do you understand by the term job time – out and how can you overcome that?
how to do automated restart when a job abends?
What is Cataloged Procedures?
what is SOC4 error?
I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?
In job processing, what happens in execution stage?
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u
Is their any set of rules for dd? Explain.
When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?
when can a job time-out occur? How to overcome that?
