How to exclude the duplicate records from two concateded
flat files (records from both files must be removed)?
Answer / 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 |
How much space OS allocates when you create a PS or PDS?
I have 10 steps, I want to run STEP1 TO STEP4 then I should not run STEP5 and STEP6. Aganin I want to execute from STEP7 to STEP10. ONLY using CONDITION CODES how can we execute this process? 1. Where we can set cond codes for STEP5 and STEP6? 2. How can we execute remaining steps from STEP7 to STEP10?
what is the difference between return code and maxcc?
There are two input sorting files and there is a need to create one sort out file which contains data of both input files. What is the sort card for this. Write a sample JCL for this using a control card?
What is the function of dd disp parameter?
Explain about LMGET�read a logical record from a data set
MOD, DELETE; What does a disposition of (,DELETE) mean ?
whats SOC7?
Name the statement which can be used to send data to another mvs jes3 node?
What is COND=ONLY ?
Can we use COND=EVEN on a job card, when jobs are scheduled through scheduler?
Please explain with syntax and an example, the Inrec fields and Outrec build in sort.