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
Explain the hierarchy levels in jcl?
What is the difference between run mode and addressing mode?
what is JCL?
Explain how can return codes be tested before execution of a job step?
Explain how can a jobs execution priority be modified?
List in order the hierarchical levels of jcl?
What is 'mounting' of volumes ? Is there anything that a programmer can do in it ? How to find currently mounted volume ?
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?
When space is allocated for an output dataset, what units can be used?
How can the attributes of one sms dataset be copied to another dataset?
What is use of restart and how to use it?
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
how do you access an uncataloged dataset in a jcl?