Transaction Type | DataSource Class |
NO_TRANSACTION, LOCAL_TRANSACTION | com.ibm.as400.access.AS400JDBCDataSource |
XA_TRANSACTION | com.ibm.as400.access.AS400JDBCXADataSource |
Parameter | Description |
TransactionIsolation | If you are accessing a table with the <current catalog>.<current schema> qualifier, set the transaction isolation level and also specify the Libraries property. TransactionIsolation=none; Example of TransactionIsolation and Libraries: TransactionIsolation=none;Libraries=QGPL |
Libraries | If you are specifying the transaction isolation level, you must specify the Libraries property as shown: Libraries=QGPL; |
Parameter | Description |
clischema | Use the clischema property to enable or disable adapter polling notifications when the systriggers view is not in the default schema. For example: clischema=schema_name For example, if you specify clischema=QSYS2, when enabling or disabling a notification, the adapter issues the following query: SELECT trigger_name FROM QSYS2.systriggers |
metadatasource | Use the metadatasource property if the StoredProcedure adapter service calls a stored procedure with a procedure name that is different from its specific name. For example: metadatasource=1 |
Driver | Server Name | User | Password | Database Name | Port Number | Network Protocol |
JTOpen v4.1 for DB2 for AS/400 v4r5, v5r1, v5r2, v5r3, and v5r4 | Yes | Yes | Yes | No | No | No |