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 have a File that has duplicate records. I need only those
records that occur more than thrice.

Answer Posted / jammi

can use icetool utility to can select the records which has
more than thrice or more
//sysin dd *
select from(idd) to(outdd) on(stpos,leng,type)
nodups/alldups/lower(n)/higher(n)/equal(n)

set n=3 in higher rest are optional try this and let me know

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

10172


What are the rules employed while naming the steps in a job?

1149


Name the parameters which can be used to limit the number of records written to a sysout dataset?

1160


What is the use of disp parameter?

1146


what sort card you will use to copy the data from one dataset to another dataset?

1236


What is the function of //jcllib statement?

1327


Can I send output of job to my remote device careerride123?

1137


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

1219


How dummy is used in jcl?

1158


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

1393


How to submit a jcl from cics?

1158


how would you create a temporary dataset? And where will you use them?

1418


What do you know about jcl?

1145


What is the significance of addrspc parameter in the exec statement?

1088


when does a dataset go uncataloged?

1325