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 / sk

Sort the file in decrement order , the key of sort is
Company name and company code, and also use SUM FIELDS =
NONE , then it will remove the duplicates also

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you

599


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

844


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

666


how to compare two datasets without using superce because output is limited to 133 bytes

1476


Explain how can an in-stream dataset be terminated?

687






List the different jcl statements that are not permitted in the procedures?

631


What do you know about jcl?

643


when can a job time-out occur? How to overcome that?

743


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

645


if the submitter of a job wants to inform another user about the job completion, how can it be done?

744


The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The disp in the JCL is SHR and the pgm opens the file in EXTEND mode. What happens ?

933


What does a disposition of (new,catlg,keep) for a dsn mean?

602


What are the jcl procedures?

640


What is Cataloged Procedures?

706


Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You

2258