Is it possible within a Cobol program to link tables together from different product lines?
For my purposes I want to be able to link the employee number from the HRSUPER table in our PROD product line to the WEBUSER table in the LOGAN product line.
If this is possible could you please post a code snipet of the cobol program.
Thanks for any and all help!!!
The easiest way to do this is to create a VIEW of the PROD/HRSUPER table in Logan and using DBDEF to define it in a dbspace where it is "Is View". That way you can READ it as if it were a local table, but you cannot INSERT or UPDATE the data (a smart thing). Check your Enterprise Database Server Administration manual for instructions on defining a VIEW.
g'luck!
Thanks a lot schroncd, I'll read up on how to do that.