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

how are instream data terminated?

3 Answers   Tech Mahindra,


Can you give the sort card to arrange the specific column in the version of GDG.

1 Answers  


can we bowse or edit the GDG dataset if it is a tape entry?

4 Answers  


Why include statement is used in a jcl?

0 Answers  


wht happens if blksize = 0 and lrec = 0 ?

1 Answers   TCS,


How many instream we can write in single jcl?

1 Answers  


How to pass values in jcl to cobol?

4 Answers   IBM, Infosys,


how many max steps can we use in a job? pls answer to my question

9 Answers   TCS,


What are steplib and joblib? What for they are used?

0 Answers  


My JOB contains three steps. //STEP1 EXEC PGM=ABC //STEP2 EXEC PGM=DEF //STEP3 EXEC PGM=GHI My Question is 1) I want to execute second step only. How will do. 2) Soppose U consider above three steps are in PROC steps and I want execute the PROC second step only? How to execute the second step only. During exection time its creating any ABEND? Please let me know..........

2 Answers  


Statement1 "We can not use UNCATLG in SMS managed VSAM datasets" Statement2 "We can not delete a SMS managed data set without UNCATLG it" (P-353, Saba Zameer book) Then how do we delete SMS managed VSAM datasets ?

1 Answers   IBM,


describe the dd statement,its meaning,syntax and keywords?

1 Answers  


Categories