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...


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



oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records..

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

oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records..

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

oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records..

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

Post New Answer

More JCL Interview Questions

can u execute a proc from another proc?

5 Answers   Logica CMG,


In one of intervie, my interviwer asked, I have a file which contains 4 records I would like to split the 4 different outputs for each record how to do?

14 Answers   Cap Gemini, Cognizant, JPMorgan Chase, TCS, Xansa,


which utility is used a dummy utility?

0 Answers   IBM,


Explain about User Information

1 Answers  


How many steps we can overide in the proc's?

2 Answers   CS,


Is CPU time (TIME parameter) assigned to a JOB and JOBSTEP BOTH, by default ?

6 Answers   IBM,


What are the causes for S0C1, S0C4, S0C5, S0C7, S0CB abends ?

11 Answers   Tesco,


what is fixed length and variable length and difference between them

1 Answers   CGI, Wipro,


What do you know about jcl?

0 Answers  


Describe the various parameters utilized in the creation of a gdg?

0 Answers  


what is the alternative to model parameter?

0 Answers  


Describe the DD statement, its meaning, syntax and keywords?

2 Answers  


Categories