If we want to see the eliminated duplicate record thru
SORT, how its output file will be managed
- 6 Answers
- 10300 Views
- Syntel, I also Faced
- E-Mail Answers
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
what is use of dsn parameter in dd statement?
What is the use of disp parameter?
What is catelog procedure and how many catelog procedure to use in one job?
Explain the job statement in jcl?
which parameter is used to check the syntax of a jcl without executing it?
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
which utility is used to run a cobol-db2 program?
Can we use DISP=SHR in output file in JCL
if the submitter of a job wants to inform another user about the job completion, how can it be done?
how can you check if a file is empty using jcl?
Explain how can return codes be tested before execution of a job step?
What does a disposition of (MOD,DELETE,DELETE) mean ?
How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
How can a fb file convert to vb file using sort program?
Explain in DD statement what is the use of DCB parameter?
