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?

Answer Posted / ram

SORT FIELDS=(2,5,CH,D)
DUPKEYS MAX=(13,1,ZD)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If a (+1) generation dataset is created in the first step of a job, how can it be referenced in later steps of the same job for input?

775


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

769


Explain the function of dd name parameter with a 2 part structure; audit.report?

886


Explain the purpose of the dd keylen parameter?

663


What parameter directs the output of the job log dataset?

759






what are the various stages of job processing?

729


what are JCLLIB and STEPLIB in JCL?

667


how to do automated restart when a job abends?

837


Explain how can the attributes of one sms dataset be copied to another dataset?

699


How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY

854


Explain about LMQUERY�give a dialog information about a data set

894


what operation is performed by job statement?

652


which utility is used to run a cobol-db2 program?

797


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.

1982


what is use of disp parameter in dd statement?

652