I need some clarification regarding sorting.
//S010 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SORTIN DD DSN=MSI1390.TEST.INFILE,DISP=SHR
//SORTOUT DD DSN=MSI1390.TEST.OUTFILE1,DISP=SHR
//SORTXSUM DD DSN=MSI1390.TEST.OUTFILE2,DISP=SHR
//SYSIN DD *
by using the above code, am facing the error message :
"ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF
Now i want the unique records in SORTOUT and the eliminated
duplicates in SORTXSUM...How can i do this?
also...we dont know the difference b/w DFSORT and
SYNCSORT...how and when to use SYNCSORT
the error "ICE172A" says that the SORT Tool used by your
shop is ICETOOL and so the SYNCSORT tool options cannot be
used in this case. If you would like to confirm what is the
sort tool that your shop is using, try to do a Quick ref
(eg: QW SORT) at the command line and find which is the
tool that is installed. Also, you can achive similar
results by using the NODUPS options with ICETOOL. There is
a difference b/w NODUPS and SUM FIELDS=NONE. NODUPS will
eliminate all the related duplicate records along with its
first occurrence, but, in SYNCSORT, the first occurence of
the duplicate record will not be removed from the main
Hope this answers!!
DFSORT does not support the XSUM parameter provided by a
product to write records deleted by SUM processing to a
SORTXSUM DD data
set. However, ICETOOL’s SELECT operator can perform the same
XSUM with FIELDS=NONE. For example, this ICETOOL job:
u can use by this way
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SORTIN DD DSN=...
SUM Control Statement
//SORTOUT DD DSN=...
//SORTXSUM DD DSN=...
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT)-
ON(5,4,CH) FIRST DISCARD(SORTXSUM)
I need to compare two VSAm files. In input VSAM file some
fields are updating and the updated feilds are coming into
the output file. now i need to compare these two files with
respect to a perticular field. Please suggest a suitable
JCL code me.
Suppose a proc step has a DD statement like
//ABC DD DSN=TEST.FILE1,DISP=SHR
and the above DD name is overridden from the JCL as given
//procstepname.ABC DD DSN=TEST.FILE3 - Will the DD
statement now have just TEST.FILE3 or it will be TEST.FILE3
Suppose if it is overridden twice like
//procstepname.ABC DD DSN=TEST.FILE3
//procstepname.ABC DD DSN=TEST.FILE4
Will this give a JCL error? If not, what will be final