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

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name what parameter directs the output of the job log dataset?

1040


Name a few IBM utility programs, and explain its function.

4946


What is notcat 2 - gs?

1447


What is the purpose of dd?

1222


Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?

1208


write a jcl to execute a job by 7:00 am on jan 20,1986?

1100


What are steplib and joblib?

1149


what is the purpose of coding class parameter in job statement?

1241


a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?

1064


How can a jobs execution priority be modified?

1275


What do we mean by 'Virtual storage' for a dataset and for a JOBSTEP ? What is the significance of the following statement for a programmer 'Virtual storage results in program addresses being independent of the addresses that actually exist in a computer' ?

2013


In sms datasets, what is the function of the dd mgmtclas keyword?

1371


Is it possible to define dd statements as you want?

1097


Explain the function of dd disp parameter?

1099


How can an in-stream dataset be terminated?

1327