AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE
DUPLICATES HOW TO REMOVE THE DUPLICATE FILES IN JCL? CAN I
GET THE PROGRAM FOR THIS

Answers were Sorted based on User's Feedback



AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE F..

Answer / girish kumar

Yes, Sort will do it for u.
//........Pgm=sort
........
.........
.........
//sysin DD *
sort fields=copy
SUM FIELDS=NONE
/*

Is This Answer Correct ?    5 Yes 0 No

AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE F..

Answer / ksingla.vikas

A Sort program will do that for you. Just write
sumfiled=NONE. This will remove the duplicates for you.

Is This Answer Correct ?    2 Yes 0 No

AM HAVING A FILE WHICH CONTAIN 12 DATS OUT OF WHICH 4 ARE DUPLICATES HOW TO REMOVE THE DUPLICATE F..

Answer / garry

Yes, Sort will do it for u.
//........Pgm=sort
........
.........
.........
//sysin DD *
copy (complete statement)
SUM FIELDS=NONE
/*

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More JCL Interview Questions

Can we use empty VSAM as input?

9 Answers   Convergys, Kanbay,


How to send different PARM values based on the any condition to the program in a JCL? For example :- If the time is before 12:00 pm, I want to send "A" to some program and if it past 12:00 pm , I want to send "B" as a PARM value to that program. How to do it thur JCL only?

0 Answers   UHG,


describe the dd statement,its meaning,syntax and keywords?

1 Answers  


i have a ps with two columns eno and ename , i need to copy eno column values in one ps and ename column values in one Ps ? is it possible through iebgener . how ? thx in advance

1 Answers   IBM, TCS,


i am trying to copy a PS file into VSAM file in step2 by using PGM=IDCAMS,COND=(0,LT) and the pS file is getting sorted in the step1. I got the return code 00 for step1 but step2 got flushed. can u please help on this. Below is My JCL. SEPP050 EXEC PGM=SORT,REGION=6144K SYSIN DD DSN=SYSCMN.PROD.CCLIB (F5910BNN), DISP=SHR SYSOUT DD SYSOUT=* SYSUDUMP DD SYSOUT=A SORTIN DD DSN=Z1225BT.F5910EPP.HISOUT, DISP=SHR SORTOUT DD DSN=Z1225BT.F5910EPP.HISOUT.SORTOUT5, DISP= (NEW,CATLG,DELETE),UNIT=DELQ, SPACE=(CYL, (500,500),RLSE), DCB= (RECFM=FB,LRECL=1606,BLKSIZE=16060,BUFNO=15) SORTWK01 DD UNIT=SYSDA,SPACE=(CYL, (1)) SORTWK02 DD UNIT=SYSDA,SPACE=(CYL, (1)) SORTWK03 DD UNIT=SYSDA,SPACE=(CYL, (1)) SORTWK04 DD UNIT=SYSDA,SPACE=(CYL, (1)) SYSIN1 DD UNIT=VIO,SPACE= (80,1) * SEPP060 EXEC PGM=IDCAMS,COND= (0,LT) SYSPRINT DD SYSOUT=* SYSOUT DD SYSOUT=* SYSLIST DD SYSOUT=* *** DD01 DD DSN=Z1225BT.F5910EPP.HISOUT.SORTOUT, // DISP=SHR //*** //DD01O DD DSN=Z1225BT.F5910PHS, // DISP=SHR, // AMP=(AMORG,'BUFND=12,BUFNI=5') //SYSIN DD DSN=SYSCMN.PROD.CCLIB(F5910BBB), // DISP=SHR Output RC for the two steps: SDCBPJ05 SEPP050 00 236 .00 .00 .0 SDCBPJ05 SEPP060 FLUSH 0 .00 .00 .0

3 Answers  






hi friends........if u know syntax of IEBEDIT IN JCL

2 Answers  


is step name is compulsory in jcl ?

2 Answers  


I am having one step in my jcl.in that step,i am calling one proc.In that proc,i have 10 steps.i want to call a particular step in that proc without writing any new jcl ike iebedit utility...

2 Answers   Satyam,


I have GDG defined e.g. GDG.smaplegdg.base, after processing the GDG. it contains some records and which is input to the second step2. How can I use GDG to use it as input file at step2.

3 Answers   Wipro,


How do you handle empty files in a JCL ?

3 Answers   Wipro, Xansa,


Define concatenating?

0 Answers  


1) max no of steps with jcl job can execute 2) how many extentions r possible in sequencial files with job 3) what is set parameter will do 4)how to get syntax errors without sub 5) what is differ between error and abend 6) hw mvs knows who submitted the job and whoom it has to forward 7) what are the positinal parameters of data descripter

1 Answers   L&T,


Categories