Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What are the parameter we cannot use in procedure? How many instream we can write in single jcl?

1076


how can you check if a file is empty using jcl?

1424


What are the 2 types of parameters in dd statement?

1158


How do you submit a job for execution?

1111


Is automatic restart possible in jcl? If yes, how?

1116


What are hierarchy levels in jcl?

1522


When The Define Jcl Is Not Available, How Can You Get Information About A Vsam File's Organisation ?

1226


What is jcl in mainframe, and how many types of jcl statements are there for a job?

1196


Explain the purpose of dd * statement in jcl?

1071


How do you overcome this limitation ?

1206


how you will the direct the data to spool using sysout option?

2434


Explain the function of dd disp parameter?

1124


Name what parameter directs the output of the job log dataset?

1054


Can we use DISP=SHR in output file in JCL

1421


Explain how can an in-stream dataset be terminated?

1326