Interested to Buy Any Domain ? << Click Here >> for more details...
IN DFSORT sum fields=none is usec to remove duplicates.how
to write the duplicates in another dataset?
- 2 Answers
- 13666 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu s reddy
.
.
//SORTXSUM DD DSN=UID.DUPS,DISP=SHR
//SYSIN DD *
SORT FIELDS = (10,5,CH,A)
SUM FIELDS = NONE,XSUM
/*
.
.
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How can an in-stream dataset be terminated?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
Name a few IBM utility programs, and explain its function.
I want to join to input files and write the matching fields on to an output file but i dont want the output file a sorted one
What is the function of the dd mgmtclas keyword in sms datasets?
Where can program checkpoints be stored for use in a restart?
How can unused space allocation be returned to the system when a dataset is closed?
Is their any set of rules for dd? Explain.
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
When space is allocated for an output dataset, what units can be used?
Is condition checking possible in jcl?
Where & How Do You Code Identifier In Jcl?
how to compare two datasets without using superce because output is limited to 133 bytes
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
