Answer / mahaveer

//SORTXSUM DD DSN=datasetname,
// DISP=(NEW,CATLG,DELETE),UNIT=SYSDA,
// SPACE=(CYL,(1,4),RLSE),
// DCB=(RECFM=FBM,LERCL=80,BLKSIZE=800)
.
.
//SYSIN DD *
SORT FIELDS=(1,3,CH,A)
SUM FIELDS=NONE,XSUM
/*

We can see the eliminated duplicate records in sortxsum

Answer / chandrakant sinha

To remove duplicates we need to give :

SUM FIELDS = NONE

in SYSIN DD *

Answer / 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=*

Answer / subramanyam reddy

//sysin dd *
sortfields=(1,3,ch,a)
sumfields=none,xsum
/*
//
where 1 is starting postion
3 is length
'ch' means charactor
'a' assending

Answer / devendra acharya

for eliminating duplicate record thru sort
we use
SORT FIELDS = SUM
in SYSIN DD*.

Answer / devendra acharya

it can be happen by using
SORT FIELDS=COPY

A job has 90 steps i want to execute only step7 and step15

3 Answers   Cognizant,

oza017.myorg.emp has 100 records ,oza018.myorg.staff has 200 records but 50 are the common records in both files copy all the common records into oza017.myorg.xyz dataset

3 Answers   Cognizant,

What statement can be used to send data to another mvs jes3 node?

0 Answers  

Explain about ISPF/TSO Commands

0 Answers  

how can we pass parameters from JCL to cobol subprogram...my requirement is i should not get data from mainprogram but i need it from JCL directly

5 Answers   IBM, TCS,

What is the difference between these two parameters? -> accounting information -> class how would it bring the differrence to a program?

4 Answers  

Hi, can any one tell about " How do u eliminate the duplicates "

2 Answers   Cap Gemini,

How to find the length of variable length copybook using fileaid ??

1 Answers   CSC,

//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 /*

0 Answers  

Explain how can an in-stream dataset be terminated?

0 Answers  

What will happen if two JOB statements are mentioned in an JCL continuously.

2 Answers   IBM,

How does -818 sql error occur? Why does it happen and what can be done to overcome this error code?

5 Answers   RBS,