Hi, can any one tell about " How do u eliminate the
duplicates "
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
what operation is performed by job statement?
I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?
What is the motivation behind coding class parameter in job statement?
What dd statement is used to supply the name of a dataset?
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
what is the difference between JES3 and JES2?
What is condition checking in jcl? Is this possible?
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?
How do you submit a job for execution?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
What is the function of //jcllib statement?
Is automatic restart possible in jcl? If yes, how?
WORKING-STORAGE SECTION. 01 GROSS-PAY. 05 BASIC-PAY PIC 9(5). 05 ALLOWENCES PIC 9(3). PROCEDURE DIVISION. MOVE 1000 TO BASIC-PAY. MOVE 250 TO ALLOWENCES. DISPLAY GROSS-PAY. STOP RUN. 77 W-A PIC 9(3)V99 VALUE 23.75 77 W-B PIC ZZ9V99 VLAUE 123.45 after the statement MOVE W-A TO W-B what will be W-B's value? a.123.75 b.b23.75 (where b indicates space) c.023.75 d.invalid move
How does jcl act on code(if you take a cobol program)?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?