How to get the last but one duplicate record of the file
using Sort?

Answer Posted / vikas pujar

Sort Dataset SORTXSUM will hold the duplicate records if in
Sysin dd *, we give option XSUM, after SUM FIELDS=NONE. So
last but one record in dataset should be the answer.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the compile process of cobol program expalin with code

2307


What are the 4 fields in dd statement?

925


can any one plzzzzzz tell the jcl code for creating ps using idcams

11074


what happens in execution stage in job processing?

835


how would you create a temporary dataset? And where will you use them?

999


How can the disposition of sysout datasets be set for an entire jobstream?

1083


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?

9413


What is timing concept in mainframe?

1901


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?

824


My Question is 1. How to cound no. of records in JCL. Please explain with an example. 2. How to execute only odd steps in JCL? I know EDIT TYPE = Inculde, Step Name = 1,3,5 and COND code for all even step. Anyone knows other than this.

2209


I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?

1064


What is one line to pass PARM from JCL to COBOL?

4664


What is the function of //jcllib statement?

1043


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

1074


Explain the function of //jcllib statement?

932