Resource Manager Definition for Generic One-phase Commit for ODBC Switch Module

To define the generic one-phase commit for ODBC XA switch module in Enterprise Server, add an XA resource including the following values.

• In the Module field, enter the full path to ESODBCXA.so (32-bit) or ESODBCXA64.so (64-bit).
• In the Open string field, type the following:

  DSN=odbc_dsn[,USRPASS=userid.password]

  where the parameters are:

  odbc_dsn

  The ODBC Data Source Name used to connect to the data source as defined within your ODBC driver configuration.

  userid

  The user ID required to connect to the data source. Not required when using trusted connections.

  password

  The password required to connect the user ID to the data source. Not required when using trusted connections.

Alternatively, you can specify the DSN, user ID, and password by manually coding them into the ESODBCXA.CBL source. This can be helpful if you want to ease security. To do this, search for CUSTOMIZE within ESODBCXA.CBL to see where to apply the required changes.