How to exclude the duplicate records from two concateded
flat files (records from both files must be removed)?
- 1 Answers
- 5235 Views
- I also Faced
- E-Mail Answers
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 |
Explain about RECORDING MODE Clause
hi guys what r the diff types of procs in jcl? bye ramya
4 Answers ACS, Keane India Ltd,
The maximum number of steps in a job?
Explain how can the submitting users racf authority be overridden in a job stream?
once we submitted the job to the operating system, how can we cancel the job before execution?
What is model dataset label(Model DSCB)?
What all are the changes to be made in JCL so as to do testing?
jcl is like a complier....?
Explain COND used in JCL?
What is the difference between Sysin,Sysout,Sysdbout and Sysudump?
How can values be passed from the job stream to an executable program?
shall we concordinate two different length dataset in to a new date set.
COBOL 
