//Sysin dd * sort fields=(1,5,ch,A) sum fields= none /* // i

Hi, can any one tell about " How do u eliminate the
duplicates "

Question Posted / bhaskar reddy

2 Answers
6516 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain the purpose of the dd keylen parameter?

1143

What are s0c1, s0c4, s0c5, s0c7 and socb?

1154

What is the function of dd name parameter with a 2 part structure; audit.report?

1213

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

1039

How is the record format of an output dataset specified?

1139

//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 /*

1436

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' ?

2011

List the various advantages of using jcl language?

1434

Explain how can the submitting users racf authority be overridden in a job stream?

1112

Brief description of inline procedure of jcl.

1230

I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?

10098

What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?

2273

What is condition checking in jcl? Is this possible?

1099

I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?

1163

Suppose I have five jobs to do. But I want to hold one?

1113