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
- 6310 Views
- TCS, I also Faced
- E-Mail Answers
Answer / 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 |
How do you create a temporary dataset? Where will you use them?
Is stepname is a MUST and should be unique also for each JOBSTEP ? or system can supply the stepname for a step which is not given a name by the programmer ?
How to Enter The Spool Area In Real Time?
the command to open a dataset directly from the JCL instead of opening it separately using 3.4 option.
what is the resolution for sb37 error
What is DSNDB06 ?
What is a JCL Command statement ?
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
What is DISP= (NEW,PASS,DELETE)?
what is the cond=even only
The maximum number of in-stream procedure you can code in any JCL is ?
Is it possible to code instream data in a PROC?
COBOL 
