Interested to Buy Any Domain ? << Click Here >> for more details...
We are aware of eliminating the duplicate records from
outyput fiel using sort utility. Can we get the duplicate
records in to another file in the Same sort utility?
- 2 Answers
- 9029 Views
- I also Faced
- E-Mail Answers
Answer Posted / sathya
we can get the duplicate records alone in the dataset using
sort utility.
//SORTTA EXEC
PGM=SORT
//SYSIN DD *
SORT FIELDS=(29,9,CH,A)
SUM FIELDS=NONE,XSUM
/*
//SORTIN DD DSN=…,DISP=SHR
//SORTOUT DD DSN=…
//SORTXSUM DD DSN=…
//SYSOUT DD
SYSOUT=*
//
The XSUM control statement is used to create
The output file with the duplicate records alone.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file
which utility is used to run a cobol-db2 program?
What is job control language?
What is the function of //cntl statement?
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) ?
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
Are there any set of rules for the names of the steps used in a job?
What does a disposition of (new,catlg,keep) for a dsn mean?
is there any way to execute more than one proc in the same exec statement at the same time..?
//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 /*
Why include statement is used in a jcl?
Is it possible to define dd statements as you want?
Is automatic restart possible in jcl? If yes, how?
how do you create a dataset in a jcl with the same file organisation as that of another existing dataset?
What are the utility programs in jcl?
