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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
  2. Suggest New Category

i have a file which contains duplicates ? my requirement is to
eliminate duplicates and these elminated duplicates should be
moved to another file can any code this using sort ?

Question Posted / visu.kanchamreddy

Answers were Sorted based on User's Feedback



i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elmin..

Answer / prabudha jain

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

1. SORT FIELDS=(1,3,CH,A) - Input file will be sorted
depending upon the key specified above 1,3,CH,A.

2. SUM FIELDS=NONE,XSUM - NONE means it will eliminate
duplicates.XSUM option will copy all records eliminated in
sort process will copy to another dataset defined in
SORTXSUM stelp

Is This Answer Correct ?    12 Yes 1 No

i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elmin..

Answer / vinay sonar

Please refer mainframe refresher by MUTTU

Is This Answer Correct ?    1 Yes 0 No

i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elmin..

Answer / snehatechm

But which duplicate record will be found in SORTXSUM.
Will it have last duplicate record or first duplicate
record.

e,g 123acvvbbnm
123bbbbbbbb
123rkrjrjjr

which record will be found in sortxsum

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More JCL Interview Questions

How do you send the output of a COBOL program to a member of a PDS?

7 Answers  

What is the difference between IEBGENER, IEBCOPY and REPRO in IDCAMS utility?

8 Answers   Accenture, TCS,

How to DEBUG a JCL?

9 Answers   Satyam,

How to pass the parameter in parm using linkage section ? (syntax)?

0 Answers   Infosys,

IIN APITUDE THEY GAVE ONLY 10 QUESTIONS.. THEY ARE SIMPLE ONE FROM NUMBER SERIES,BOATS,TIME & DISTANCE,PROFIT &LOSS,FIND OUT THE NUMBER ? 9 25 4 36 81 64 49 AND surveillance SPELLINGS E.T.C

0 Answers  

How to execute step2,step1,step3 when step1,2&3 are in order

6 Answers   TCS,

how to convert fb to vb in jcl ?

5 Answers   IBM, Infosys,

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 can you check if a file is empty using jcl?

0 Answers   IBM,

how many members can be created inside a single pds?

8 Answers  

List in order the hierarchical levels of jcl?

0 Answers  

Is it possible to define dd statements as you want?

0 Answers  

For more JCL Interview Questions Click Here
Categories