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
What are the parameter we cannot use in procedure? How many instream we can write in single jcl?
how can you check if a file is empty using jcl?
What are the 2 types of parameters in dd statement?
How do you submit a job for execution?
Is automatic restart possible in jcl? If yes, how?
What are hierarchy levels in jcl?
When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?
What is jcl in mainframe, and how many types of jcl statements are there for a job?
Explain the purpose of dd * statement in jcl?
How do you overcome this limitation ?
how you will the direct the data to spool using sysout option?
Explain the function of dd disp parameter?
Name what parameter directs the output of the job log dataset?
Can we use DISP=SHR in output file in JCL
Explain how can an in-stream dataset be terminated?