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
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?
What are the rules employed while naming the steps in a job?
Name the parameters which can be used to limit the number of records written to a sysout dataset?
What is the use of disp parameter?
what sort card you will use to copy the data from one dataset to another dataset?
What is the function of //jcllib statement?
Can I send output of job to my remote device careerride123?
Explain how can the attributes of one sms dataset be copied to another dataset?
How dummy is used in jcl?
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
How to submit a jcl from cics?
how would you create a temporary dataset? And where will you use them?
What do you know about jcl?
What is the significance of addrspc parameter in the exec statement?
when does a dataset go uncataloged?