DSNRLI is typically used as part of the SQL process to connect, open, execute SQL calls, commit, rollback, close, and disconnect. However, the Micro Focus DSNRLI functions used in this process are shown in the table:
Process | DSNRLI Function | tx_CALL |
---|---|---|
Connect | IDENTIFY | tx_associate |
SIGNON | tx_open | |
Open | CREATE THREAD | tx_begin |
Commit | SRRCMIT | tx_commit |
Rollback | SRRBACK | tx_rollback |
Close | TERMINATE THREAD | tx_close |
Disconnect | TERMINATE IDENTIFY | none |
For user executed SQL calls, use existing SQL architecture.
Multiple XA Resources can be used in a single unit of work. In those cases, the application should use DSNRLI IDENTIFY, SIGNON and CREATE THREAD calls to associate each additional XA Resource.