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

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
  2. Suggest New Category

what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file

Question Posted / annie

Answers were Sorted based on User's Feedback



what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / sv

sort fields = copy
sum fields = none,xsum

Is This Answer Correct ?    12 Yes 3 No

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / arthi

JOINKEYS F1=FILE1,FIELDS=(1,10,A)
JOINKEYS F2=FILE2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCHED,INCLUDE=(22,1,CH,EQ,C'B')
OUTFIL FNAMES=UNMATCHED,INCLUDE=(22,1,CH,EQ,C'N')

Is This Answer Correct ?    4 Yes 0 No

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / vinodh

Refining the above sort card statement after executing it

SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCH,INCLUDE=(22,1,CH,EQ,C' ')
OUTFIL FNAMES=UNMATCH,INCLUDE=(22,1,CH,EQ,C'N')

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More JCL Interview Questions

Can anyone tell me the syntax for printing two files at two different destinations in a single step?

3 Answers  

what happens when time=0 is given in jcl code. what happens when blksize=0 is given in jcl code. what is symbolic and overriding parameters and a example program.

6 Answers   HCL,

What is the difference between a PDS member and a GDG Generation ? Is it only this, that with a generation we can use +1, 0, -1 etc while with PDS member we can not ?

7 Answers   IBM,

what do you mean By spooling? Expand SPOOL?

4 Answers  

in catalog procedure i have step1 dd dsn=filea dd dsn=fileb dd dsn=filec ur concatenaning all the files. but i need to override fileb with file 2 ? can anyone give the ans pls for ths

1 Answers   DELL,

Explain about Specifying compiler options in the PROCESS (CBL) statement

1 Answers  

What is DYNAMBR in jcl?

2 Answers   CTS,

Which COND paramter will u use to execute the step only if the previous step does not execute

3 Answers   BoA, HSBC,

Max. No of DD statements in a job ?

4 Answers   CSI,

How do you check the syntax of a JCL without running it?

17 Answers  

I have 2 steps in my exec statement , in first step I am creating a gdg, and the output of this step is going into second step as a input, and this second step is abended , now how could i approach in this case.

5 Answers   Bank Of America,

what is the cond=even only

4 Answers   EDS,

For more JCL Interview Questions Click Here
Categories