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.
- 3 Answers
- 13657 Views
- I also Faced
- E-Mail Answers
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 does a disposition of (new,catlg,keep) for a dsn mean?
What is the use of symbol // in jcl?
What is the function of the steplib dd statement?
What is the purpose of dd dummy statement?
What is condition checking in jcl? Is this possible?
What is the use of disp parameter?
what is the resolution for sb37 error
Explain the function of dd disp parameter?
what is the JCL statement consists of?
how would you create a temporary dataset? And where will you use them?
I have a COBOL program that ACCEPTs some input data. How do you code the JCL statement for this?
//S10 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //CON DD DSN=VAR.INPUT1,DISP=SHR // DD DSN=VAR.INPUT2,DISP=SHR //OUT DD DSN=VAR.OUTPUT,DISP=(NEW,CATLG,DELETE), // SPACE=(CYL,(5,5)),UNIT=SYSDA //TOOLIN DD * * Splice the needed data from the two VB files together SPLICE FROM(CON) TO(OUT) ON(5,5,CH) WITHALL - WITH(12,5) WITH(22,20) VLENMAX /*
which utility is used to sort a file in jcl?
A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?
What dd statement is used to supply the name of a dataset?
