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

if time parameter is not coded on the job card and job step then what is the default time assigned to the entire job and for each step in the job by the systyem ?

2 Answers   ITC Infotech,

What is concatenating?

0 Answers  

How do you find which GDG is using which dataset?

3 Answers   Patni,

In sms datasets, what is the function of the dd mgmtclas keyword?

0 Answers  

What is default if we don't specify RD parameter at all ?

1 Answers   IBM,

What are the utility programs in jcl?

0 Answers  

What are three major types of JCL statements? What are their functions?

1 Answers  

in production region 100 steps are running,but i need to run only step5 without changing code how can i do it?

4 Answers   HCL,

If the proc stepname is excluded while overriding the COND, TIME, REGION and PARM parameters while calling the proc, will the override only apply to the first step in the proc or all the steps for all the above parameters?

2 Answers  

How can we see data in TEMPARARY DATA SET in JCL ?

7 Answers   CSC, Polaris,

I have 5 steps in my job. say s1, s2, s3, s4, s5 //s1 exec ............. //s2 exec ............ //s3 exec .......... //s4 exec ........ //s5 exec ............... my question is i want to exeute only s2 and s4 steps... please advice me how to do this:

4 Answers   ITC Infotech, TCS,

A statement about PROCs is " In PROCs, Symbolic Parameters can be assigned on PROC and EXEC", BUT On which EXEC, (i) On the JCL's EXEC which is calling to PROC1. (Inside JCL, EXEC PROC1) (ii) or On the PROC's EXEC where it calls the PGM1. (Inside PROC, EXEC PGM=PGM1)

2 Answers   IBM,