AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE
DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I
GET THE PROGRAM FOR THIS

Answers were Sorted based on User's Feedback



AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE F..

Answer / girish kumar

Yes, Sort will do it for u.
//........Pgm=sort
........
.........
.........
//sysin DD *
sort fields=copy
SUM FIELDS=NONE
/*

Is This Answer Correct ?    5 Yes 0 No

AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE F..

Answer / ksingla.vikas

A Sort program will do that for you. Just write
sumfiled=NONE. This will remove the duplicates for you.

Is This Answer Correct ?    2 Yes 0 No

AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE F..

Answer / garry

Yes, Sort will do it for u.
//........Pgm=sort
........
.........
.........
//sysin DD *
copy (complete statement)
SUM FIELDS=NONE
/*

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More JCL Interview Questions

How to point my proc to production dataset always though i keep jcllib order=development.dataset? Is it possible?

3 Answers  


I HAVE A SEQUENTIAL FILE CONTAINING ONE RECORD IN WHICH I HAVE ONE FIELD AS CUSTOMER IDENTITY NUMBER FIELD WHICH IS A SIGNED FIELD. HOW TO SEQUENTIALLY INCREMENT THIS FIELD USING OVERLAY PARAMETER?.

1 Answers  


How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?

0 Answers   IBM,


I have two input SORTIN files and We need to create one SORTOUT file which contains data of both input files. What is the SortCard for this?. Suppose the length of the both files are different, then How we do it? Please reply ASAP

4 Answers   CSC,


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

0 Answers   IBM,






what is the use of IEBGENER utility?

0 Answers  


when can a job time-out occur? How to overcome that?

0 Answers   IBM,


1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat

1 Answers   Tesco,


How to send notification to multiple users through jcl???

8 Answers  


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

0 Answers  


what is use of dsn parameter in dd statement?

0 Answers   IBM,


how to see the latest generation in gdg?

3 Answers   Deloitte,


Categories