Interested to Buy Any Domain ? << Click Here >> for more details...
How to exclude the duplicate records from two concateded
flat files (records from both files must be removed)?
- 1 Answers
- 5744 Views
- I also Faced
- E-Mail Answers
Answer Posted / mayank
We can use SORT to exclude the duplicate
SORT FIELDS=NONE remove the dup from fileC
//STEP1 PGM=SORT
//*** concatinated input files
//SORTIN DD DSN=FILEA,DISP=SHR
// DD DSN=FILEB,DISP=SHR
//** output file contains records except for duplicate
//SORTOUT DD DSN=FILEC,
// DISP=(NEW,CATLG,DELETE),
// VOL=SYSDA,
// SPACES=(CYL(1,1),RLSE),
// DCB=(LRECL=80,RECFMT=F,BLKSIZE=0)
//** give the sort parameter in below sysin
//SYSIN *
SORT FIELDS=(start postion of rec, length of
rec,attribute, A/D)
SUM FIELDS=NONE
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
In job processing, what happens in execution stage?
what is the use of IEBGENER utility?
What is the function of the dd dcb keyword?
What dd statement is used to supply the name of a dataset?
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 dd statement in jcl?
Is automatic restart possible in jcl? If yes, how?
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) ?
Suppose I have a program in cobol name ”careerride” and want to execute the program by jcl. Specify the process?
List the various advantages of using jcl language?
how JCL works?
what is the compile process of cobol program expalin with code
State the uses of syspring, sysin, sort fields, sum fields and dummy.
Is their any set of rules for dd? Explain.
Explain the function of the steplib dd statement?
