Given a input file with duplicates how to remove the
duplicate records from the file using JCL?

Answers were Sorted based on User's Feedback



Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / sudee

//STEP10 EXEC PGM=SORT,REGION=1024K
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...,DISP=SHR
//SORTOUT DD DSN=...
//SYSIN DD *
SORT FIELDS=copy
SUM FIELDS=NONE
/*
//

Is This Answer Correct ?    25 Yes 12 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / tidda

This can be done by using Sort.

1) If the first duplicate is to be kept, we use SUM
FIELDS=NONE

2) If none of the duplicates are to be kept, using SYNCTOOL
or ICETOOL, use the NODUPS option.

Is This Answer Correct ?    16 Yes 6 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / subbu

in sort field we can give SUM Fields=None

Is This Answer Correct ?    7 Yes 3 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / sreedhar naidu dhekodna

We can also use the ICETOOL SELECT Operator along with its
operands for removing duplicates.

Is This Answer Correct ?    2 Yes 2 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / vivek

You can use XSUM

Is This Answer Correct ?    0 Yes 0 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / alan at accenture

the existing record of present file and the duplicate
record of previous file wnen sort both files, if both are
duplicated records both must be removed and there is no
existing record in the file. Got it? thanksalan

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More JCL Interview Questions

what is a MODELDSCB?

1 Answers  


how to concatenate datasets

5 Answers   EDS,


How to find the number of duplicates in a file using Sort?

4 Answers   Fidelity,


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?

0 Answers  


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

0 Answers  






Is there a limit of 3273 DD statements for a JCL or for every EXEC step in a JCL?

2 Answers  


What are the jcl procedures?

0 Answers  


We have two PS files,want to compare those files and put the duplicate records in one file. Input file 1 contains(1,2,4,9,10) Input file 2 contains (1,4,5,11,12,14,16). Help me with jcl.

6 Answers  


I found in one of the jcl, gdg version being mentioned as : abc.def.ghi(-0) Can anyone tell me how referring the version as (-0) is different from referring it as (0)

2 Answers  


hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u

0 Answers   HF, iNautix,


What do you understand by the terms: joblib and steplib?

0 Answers  


1)what is compilation jcl for cobol program but it is calling another program 2)what is compilation jcl for cobol program but it is calling another program(in this, main program is pure cobol but sub program is cobol+db2 program anyone please answer me for above questions. it's very urgent

1 Answers  


Categories