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

File1 has 100 records and file2 has 200 records i want to
copy 50 records which r in both file into file3

Answer Posted / kamaldeep

We can't use SUM FIELDS=NONE,XSUM as mentioned by Harsha.
if we merge 2 files then it may be the case that input file already has duplicate records, so it will not give required output.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?

8663


What are the jcl procedures?

1171


What is one line to pass PARM from JCL to COBOL?

5011


How to submit a jcl from cics?

1207


What does a disposition of (new,catlg,keep) for a dsn mean?

1198


what is the use of IEBGENER utility?

1227


How is a type of file defined in the jcl that executes the cobol program?

1241


Describe the various parameters utilized in the creation of a gdg?

1212


i want to store 20 digits . how will u do it in cobol ?

1491


What is the syntax of JCL statement?

1291


How can a fb file convert to vb file using sort program?

1397


How to alter the parameters for the existing gdg?

1256


How dummy is used in jcl?

1202


what is the JCL statement consists of?

1257


I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?

1282