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

I had Records in file Like this Company Code IBM 2 IBM 1 IBM 4 WIPRO 3 WIPRO 2 WIPRO 9 TCS 4 TCS 6 TCS 3 i want the record of every company with highest code How can i do that?

8723


We can use PASS with permanent datasets also. THEN Which is the condition in which we may use PASS (instead of KEEP) with permanent data sets, while there is no need to specify UNIT and VOL for them like temporary data sets (in cas we use KEEP for permanent data sets) ?

1762


Explain the function of a dd statement?

670


I HAVE A VB BLOCK WHICH IS USED AS INPUT IN COBOL CONATINING SOME RECORDS CAN I CHANGE THE FILE FROM VB TO FB?

2115


write a jcl to execute a job by 7:00 am on jan 20,1986?

708






What is the purpose of dd dummy statement?

960


How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?

676


List in order the hierarchical levels of jcl?

678


I need exexution process for JCL programs

1863


what is DSN in JCL and what are the parameters to declare the DSN?

733


How to run cobol program using jcl?

662


Explain how can an in-stream dataset be terminated?

708


What parameter of the job statement is used to limit the cpu time consumed by the job?

847


What are hierarchy levels in jcl?

965


what are JCLLIB and STEPLIB in JCL?

694