If we want to see the eliminated duplicate record thru
SORT, how its output file will be managed

Answer Posted / chandrakant sinha

To remove duplicates we need to give :

SUM FIELDS = NONE

in SYSIN DD *

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of //cntl statement?

829


Explain in DD statement what is the use of DCB parameter?

653


WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99 VALUE 123.45. PROCEDURE DIVISION. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. compiler : IGYGR1080-S A "VALUE" clause literal was not compatible with the data category o subject data item. The "VALUE" clause was discarded. WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99. PROCEDURE DIVISION. MOVE 123.45 TO W-B. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. 2375

1035


What dd statement is used to supply the name of a dataset?

773


How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.

5060






What is the function of the dd mgmtclas keyword in sms datasets?

731


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

669


What is the function of the steplib dd statement?

740


Is automatic restart possible in jcl? If yes, how?

655


In job processing, what happens in execution stage?

696


List the various advantages of using jcl language?

852


Mention the types of job control statements?

685


How does jcl specify the job to the operating system?

749


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?

8670


Brief description of inline procedure of jcl.

682