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

what's the significance of freespace(0 0) and freespace(100 100)

3 Answers  

How to change default PROCLIB?

1 Answers  

what is the use of IEBGENER utility?

0 Answers  

Name the system library from which modules are retrieved at execution

2 Answers  

How do you find which GDG is using which dataset?

3 Answers   Patni,

What is the significance of addrspc parameter in exec statement?

0 Answers  

what is “Cond= even” and “Cond=only”?

0 Answers  

Explain about LMINIT - generate a data ID for a data set

1 Answers  

What all are the changes to be made in JCL so as to do testing?

2 Answers   TCS,

IF WE GIVE COND on step3 then, What does the following mean ? And Just adding to that, All the below COND are VALID as per the specifications. (i) COND = (8,LT,step1,step2) ---(AND/OR ?) (ii) COND = (8,LT,step1,step2, ONLY), (iii) COND = (8,LT,step1,ONLY) will it execute only if this condition is true or only if step1 ABENDS ? (iv) COND = (8,LT,step1,step2,EVEN), (v) COND = (8,LT,step1,EVEN) ?

2 Answers   IBM,

What is maximum length of block size?

5 Answers   Cap Gemini, Kanbay, TCS,

how can we override data definitions in jcl. can any one give detailed example

3 Answers   TCS,

For more JCL Interview Questions Click Here
Categories