Hi, can any one tell about " How do u eliminate the
duplicates "
Answer Posted / bhaskar reddy
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields= none
/*
//
if u want all dupli.in one file u can use
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields =none, xsum
/*
//
XSUM is the output file name. all duplicate records moved to
this file
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Is condition checking possible in jcl? If yes, how?
What parameter of the job statement is used to limit the cpu time consumed by the job?
How to do automated restart when a job abend?
In sms datasets, what is the function of the dd mgmtclas keyword?
What is catelog procedure and how many catelog procedure to use in one job?
what happens in conversion stage in job processing?
Describe the various parameters utilized in the creation of a gdg?
What are the rules employed while naming the steps in a job?
write a jcl to execute a job by 7:00 am on jan 20,1986?
Mention the types of job control statements?
how you will the direct the data to spool using sysout option?
//S10 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //CON DD DSN=VAR.INPUT1,DISP=SHR // DD DSN=VAR.INPUT2,DISP=SHR //OUT DD DSN=VAR.OUTPUT,DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(5,5)),UNIT=SYSDA //TOOLIN DD * * Splice the needed data from the two VB files together SPLICE FROM(CON) TO(OUT) ON(5,5,CH) WITHALL - WITH(12,5) WITH(22,20) VLENMAX /*
What is the purpose of the dd keylen parameter?
What statement marks the beginning of a job step; assigns a name to the step; identifies the program or catalogued or in-stream procedure to be executed in the step?
Name a few IBM utility programs, and explain its function.