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
What is the significance of addrspc parameter in exec statement?
how to compare two datasets without using superce because output is limited to 133 bytes
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
Explain the purpose of dd dummy statement?
How to submit a jcl from cics?
How jcl is used for testing batch programs?
how do you access an uncataloged dataset in a jcl?
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
How is a type of file defined in the jcl that executes the cobol program?
What are the parameter we cannot use in procedure?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
Explain how can a jobs execution priority be modified?
How gdg are concatenated?
We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?
What is the format of comment statement?