Interested to Buy Any Domain ? << Click Here >> for more details...
If we want to see the eliminated duplicate record thru
SORT, how its output file will be managed
- 6 Answers
- 11506 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / atreyee
//STEP1 EXEC PGM=SYNCSORT
//SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR
//SORTIN DD DSN=SORT.IN,DISP=SHR
//SORTOUT DD DSN=SORT.OUT,
// DISP=(NEW,CATLG,DELETE),
// UNIT=DISK,SPACE=(CYL,(1,10),RLSE),
//
// DCB=(*.SORTIN)
//SORTXSUM DD DSN=SORT.OUT.DUPLICATE,
// DISP=(NEW,CATLG,DELETE),
// UNIT=DISK,
// SPACE=(CYL,(1,10),RLSE),
// DCB=(*.SORTIN)
//SYSIN DD *
//SYSOUT DD SYSOUT=*
SORT FIELDS=(1,5,CH,A)
SUM FIELDS=NONE,XSUM
//SYSPRINT DD SYSOUT=*
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
which utility is used to sort a file in jcl?
What is catelog procedure and how many catelog procedure to use in one job?
what is the use of JCL?
I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?
What is the function of dd name parameter with a 2 part structure; audit.report?
how would you create a temporary dataset? And where will you use them?
What does a disposition of (MOD,DELETE,DELETE) mean ?
What is the purpose of dd dummy statement?
is there any way to execute more than one proc in the same exec statement at the same time..?
Explain how can values be passed from the job stream to an executable program?
What are steplib and joblib?
in ways data can be passed to a COBOL program from JCL?
//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 /*
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
