I have two table. First table contain Client_ID(Primary key ) and Second table contain Client_ID and Cycle_ID.
In Second table some clinets IDs are repeated with different cycle id .
We need in output file all repeated client Id On second table .
In this task two input files and one output file . These three files must be declare in COBOL as Dyanmic file allocation.
Could you please any one help me and write a Cobol code for this task.
For example
First file Second file
Client_ID Client_ID Cycle_ID
100 100 123
200 200 143
300 200 156
400 300 125
400 567
400 456
In out put file : We need only Client_ID like
Client_ID
200
400
Could you please any one write a Cobol code for this task and Kindly remind all these three files must be declare a Dyanmic file allocation.
Regards,
Prashanth