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

I have two input files
i/p1
name id-key flag date
i/p 2
name id-key date

if id-key matches in the both the files then it should
write the output file from i/p1 with flag 'Y'. It should be
done thru JCL sort card ,Please provide the info on this.

---Note : output file should have all records from i/p1
with proper Flag.

Question Posted / abuzarahamad

Answers were Sorted based on User's Feedback



I have two input files i/p1 name id-key flag date i/p 2 name id-key date if id-key..

Answer / muttaiah

Please give us a sample of both the I/P files and the data
you expect in O/P files so that it will be useful for us to
answer

Is This Answer Correct ?    0 Yes 0 No

I have two input files i/p1 name id-key flag date i/p 2 name id-key date if id-key..

Answer / vivek chandrasekaran

Give the two input files to be compared as
//SORTIN DD DSN=INPUT1,DISP=SHR
// DD DSN=INPUT2,DISP=SHR
//SORTOUT DD DSN=OUTPUT,DISP=...
//SORTXSUM DD DSN=MATCH,DISP=(NEW,CATLG,DELETE),..
//SYSIN DD *
SORT FIELDS=(11,5,CH,A),EQUALS
SUM FIELDS=NONE,XSUM

Considering name length 10 and key length 5 starting from
11 pos. XSUM will capture the duplicates. EQUALS will keep
the first duplicate record. To put 'Y' flag use OUTREC
FIELDS=(1:1,15,16:C'Y',17:17,8) considering date length 8
starting from 17 pos.



SUM FIELDS=NONE

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More JCL Interview Questions

Explain how can a jobs execution priority be modified?

0 Answers  

I have a JCL which 20 steps. How do I execute 17 th step alone (It should execute only 17ths tep.and it should not execute 18,19,20 steps??

9 Answers   IBM, Infosys, TCS, Xansa, Xchanging,

Where can program checkpoints be stored for use in a restart?

0 Answers  

Can we delete the data using IEFBR14 , IEBGENER??

5 Answers   Kanbay,

how to put a dependency on job in jcl using opc scheduler?

1 Answers   CTC,

can anyone explain me about sort in jcl with inrec and outrec ?

2 Answers   HCL,

what do you mean by include statement in jcl?

1 Answers   IBM,

what is A-MODE and R-MODE?

2 Answers  

IF we are calling a PROC from Jcl...This Proc have 3 steps in it and we want to execute only the second step using the JCL, How to do it?? Please give the answer ASAP:)

8 Answers  

What is COND=EVEN ?

9 Answers   IBM,

Can we find specific member without knowing the name of PDS or can we search a member to which PDS it belongs to? if so how?

6 Answers  

What is the function of job statement in jcl?

0 Answers  

For more JCL Interview Questions Click Here
Categories