Hi ,
We are migrating our database from DB2 z/os to DB2 UDB on UNIX.
and cobol on mainframes to AIX cobol on UNIX.
We have some cobol Db2 programs that are accessing different Databases
how do we code such type of programs in AIX cobol.
Do we need to Establish connection for accessing Each Tables
e.g
Table1 under Database1
Table2 under Database2
While Accessing These tables
do we need to connect to
connect to Database1
Exec SQL
select from table1
End-Exec
connect to Database2
Exec SQL
select from table2
End-Exec
Is this correct way for programming.
Is there any alternate approach for doing this.
and how do we compile such cobol and execute DB2 Programs.
Thanks,
Satish