Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Given a input file with duplicates how to remove the
duplicate records from the file using JCL?

Answers were Sorted based on User's Feedback



Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / sudee

//STEP10 EXEC PGM=SORT,REGION=1024K
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=...,DISP=SHR
//SORTOUT DD DSN=...
//SYSIN DD *
SORT FIELDS=copy
SUM FIELDS=NONE
/*
//

Is This Answer Correct ?    25 Yes 12 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / tidda

This can be done by using Sort.

1) If the first duplicate is to be kept, we use SUM
FIELDS=NONE

2) If none of the duplicates are to be kept, using SYNCTOOL
or ICETOOL, use the NODUPS option.

Is This Answer Correct ?    16 Yes 6 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / subbu

in sort field we can give SUM Fields=None

Is This Answer Correct ?    7 Yes 3 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / sreedhar naidu dhekodna

We can also use the ICETOOL SELECT Operator along with its
operands for removing duplicates.

Is This Answer Correct ?    2 Yes 2 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / vivek

You can use XSUM

Is This Answer Correct ?    0 Yes 0 No

Given a input file with duplicates how to remove the duplicate records from the file using JCL?..

Answer / alan at accenture

the existing record of present file and the duplicate
record of previous file wnen sort both files, if both are
duplicated records both must be removed and there is no
existing record in the file. Got it? thanksalan

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More JCL Interview Questions

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

3 Answers   Cognizant,


How to copy one PS file to multiple PS files with same data?

1 Answers  


What are the common keyword parameters in both job and exec statements

4 Answers   Cap Gemini,


01 GROSS-PAY 05 BASIC-PAY PIC 9(5) 05 ALLOWENCES PIC 9(3) if BASIC-PAY has a value 1000 and ALLOWENCES has a value of 250,what will be displayed by the statement DISPLAY GROSS-PAY a.1250 b.01000250 c.01250 d.1.250

1 Answers  


A STEP has more than 1 file as INPUT. And we have to put all these records int 1 output file. How to do ? //InputF  DD DSN=ID.File1              DSN=ID.File2              DSN=ID.File3

1 Answers   FIS,


What is jcl in mainframe?

0 Answers  


I HAVE A SEQUENTIAL FILE CONTAINING ONE RECORD IN WHICH I HAVE ONE FIELD AS CUSTOMER IDENTITY NUMBER FIELD WHICH IS A SIGNED FIELD. HOW TO SEQUENTIALLY INCREMENT THIS FIELD USING OVERLAY PARAMETER?.

1 Answers  


how to code instream data in procedure?

3 Answers  


We are using 2 files , file one has data, file two is empty.Using jcl how can we find the other file is empty?

9 Answers   CSC, IBM,


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,


I have a job which is a long-running one. Processes millions of records. Due to some run-time problem (not a problem due to the job/data) the job abends.What needs to be done to make the job complete successfully.

4 Answers   TCS,


What is the difference between Sysin,Sysout,Sysdbout and Sysudump?

3 Answers  


Categories