Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.



i have two flat files.i want to select one record from that file by using jcl.for example file1 co..

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

Post New Answer

More JCL Interview Questions

Explain the function of dd name parameter with a 2 part structure; audit.report?

0 Answers  


We are using 2 files , file one has data, file two is empty.Using jcl how can we find the other file is empty?

9 Answers   CSC, IBM,


TIME parameter in JOB statement or EXEC statement specifies What type of time (CPU time or execution time)?

5 Answers   CTS,


Can anybody tell what is tool used to generate the list of PROCS used in JCL to generate a PROCTREE

0 Answers  


How to fetch even records from one file to another file by using ICETOOL in JCL?

3 Answers  


What does IEBGENER do?

10 Answers   BirlaSoft,


How to code these statements in JCL: CLEANUP INITIAL(NO) RESTART(NO) DYNALLOC(NO) job definition..?

0 Answers  


in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?

0 Answers   IBM,


How can a job send a status message to a tso user at the completion of a job?

1 Answers  


What are the parameters that are used in creating a gdg?

0 Answers  


how do you access an uncataloged dataset in a jcl?

0 Answers   IBM,


What does a disposition of (NEW,CATLG,KEEP) mean?

1 Answers   Cap Gemini,


Categories