To complete the definition of a generic one-phase commit for ODBC XAR, add the following values in the
Open string field.
DSN=odbc_dsn[,USRPASS=userid.password]
[,USERP={T|F}][,BATCHONLY={T|F}][,LOCALTX={T|F}]
- odbc_dsn
- The ODBC Data Source Name used to connect to the data source as defined within
the Windows ODBC Data Source Administrator utility (Windows) or
your ODBC driver configuration (UNIX).
- 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.
- USERP, BATCHONLY,
LOCALTX
- See
SQL xa_open string Configuration Options for details.
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.
