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

Answers were Sorted based on User's Feedback



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

Answer / bhaskar reddy

//Sysin dd *
sort fields=(1,5,ch,A)
sum fields= none
/*
//

if u want all dupli.in one file u can use
//Sysin dd *
sort fields=(1,5,ch,A)
sum fields =none, xsum
/*
//
XSUM is the output file name. all duplicate records moved to
this file

Is This Answer Correct ?    8 Yes 1 No

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

Answer / rammateti

By using DFSORT we can eliminate the duplicates

//Sysin dd *
sort fields=(1,5,ch,A)
sum fields=
/*
//
in the above dfsort we use sum fields= empty then it
eliminate the duplicates

if u want all dupli.in one file u can use
sum fields = xsum........
by (prathap)

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More JCL Interview Questions

Hi, all suppose i have 5 steps (S1,S2,S3,S4,S5) what will happen if cond is true or false (which of the other steps get executed)? 1) //s3 exec pgm=abc,cond=(0,le) 2) //s3 exec pgm=abc,cond=(0,le,step2) 3) In the jobcord RESTART=step3,cond=(0,le) 4) can i code COND=TRUE in jobcard, if yes what will happen?

3 Answers   TCS, Tech Mahindra,


How is a dataset passed from one step to another?

2 Answers   DELL,


Explain about LMQUERY�give a dialog information about a data set

0 Answers  


What methodology can be adapted to transfer data to a program that is coded using the exec statement?

0 Answers  


What is S322 abend ?

5 Answers  






Max. No of DD statements in a job ?

4 Answers   CSI,


01 GROUP-ITEM 05 AMOUNT-1 PIC 99V9 USAGE COMP VALUE 50 05 AMOUNT-2 PIC 9(4)V99 USAGE COMP MOVE ZERO TO GROUP-ITEM ADD 50 TO AMOUNT-1 what will be the content of AMOUNT-1? a.50 b.100 c.0 d.unpredictable

1 Answers  


once we submitted the job to the operating system, how can we cancel the job before execution?

2 Answers  


What is the function of the steplib dd statement?

0 Answers  


How do you submit a JCL under CICS environment ?

1 Answers   IBM,


a jcl has 2 steps. How to code the jcl such that if step1 abends, then step2 runs. Else, job terminates with step1?

1 Answers   IBM,


What is the use of DUMMY statement in the JCL? What is the use of DUMMY Utility in the JCL?

12 Answers   Convergys,


Categories