MVSFORUMS.com

[ANDY]

Hello:

As I konw, On Windows: we use ODBC drive to connect with DB2 or other database. On Java, we use JDBC to conect with database. I do not know how to connect to DB2 on MVS using Cobol? Is there has something like ODBC on mainframe environment ?

Thanks.

Andy

[kolusu]

Andy,

Usually a typical COBOL-DB2 program will run using the TSO Terminal Monitor Program (TMP) which is IKJEFT01.The DSN command processor is the DB2 interface in here for cobol.

An IMS program can access DB2 when the external subsystem (DB2 in this case) is defined to the region. This can be probably found in the IMS.PROCLIB with a member name starting with the IMSID followed by the value of the SSM parameter for the message region.The plan name should be the same as the program name unless it is defined otherwise in the Resource Translation Table.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[ANDY]

Hi Kolusu:

thanks.

Andy
_________________
cheers,
Andy