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

Wrete a JCL to compare two files and mached records move to
onc file & un mached rows wants to another file?

Answer Posted / rams

Every one answered well. I would like to emphasize on few
details.

SORTXSUM and ICETOOL are used to identify the duplicate
records Depending on what kind of SORT utitlity you are
using. SORTXSUM works in SYNCSORT. It does n't work in
DFSORT ( you can use ICETOOL in this case ).

If you use the above ICETOOL code for comparing 2 SORTIN
files, The results may not be accurate because the record
may be duplicated in the second file and does not exist in
the first one.

When you use SUM FIELDS=NONE, you need to specify a key
based on which the duplicated can be deleted, IF you use
SORT FIELDS=COPY it may not work ( or delete duplicates by
entire record...i am not sure though)

There is a small diff in the ICETOOL and SORTXSUM work. If
you have 1,2,3,4,4,4,5,5,6,7 in you i/p file.
The SORT ourfile will have 1,2,3,4,5,6,7 and SORTXSUM file
will have 4,4,5.
The ICETOOL ALLDUPS will have 4,4,4,5,5 and NODUPS file
will have 1,2,3,6,7.

Is This Answer Correct ?    20 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is their any limit for data sets?

1151


The disp in the JCL is MOD and the program opens the file in OUTPUT mode. What happens ? The disp in the JCL is SHR and the pgm opens the file in EXTEND mode. What happens ?

1521


how you can access an uncataloged dataset in a JCL?

1095


My Question is 1. How to cound no. of records in JCL. Please explain with an example. 2. How to execute only odd steps in JCL? I know EDIT TYPE = Inculde, Step Name = 1,3,5 and COND code for all even step. Anyone knows other than this.

2422


what is “Cond= even” and “Cond=only”?

1265


Can an individual step be restricted from using all the jobs allowed cpu time?

1523


How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length ----TRY

1334


what happens in execution stage in job processing?

1109


Is it possible to left uncode disp?

1165


have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file

1472


Which dd parameters are required?

1132


what is SOC4 error?

1187


I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.

1190


how do you access an uncataloged dataset in a jcl?

1671


Are there any set of rules for the names of the steps used in a job?

1075