DB_TRANSACTION_OBJECT_INFO table function
The DB_TRANSACTION_OBJECT_INFO table function returns the object level status of objects under commitment control for a commitment definition.
An object can appear in the result more than once if it was changed more than once during the current logical unit of work.
The information returned is similar to the values shown by Display Object Level Status within the Work with Commitment Definitions (WRKCMTDFN) CL command.
Authorization: None required when the creator of the commitment definition matches the effective user of the thread. Otherwise, the caller must have *JOBCTL special authority or be authorized to the QIBM_DB_SQLADM or QIBM_DB_SYSMON function usage identifier.
- lock-space-id
- A character string that contains the lock space identifier of the commitment definition to use.
The result of the function is a table containing rows with the format shown in the following table. All the columns are nullable.
| Column Name | Data Type | Description |
|---|---|---|
| ORDINAL_POSITION | INTEGER | The relative position of this row in the result data set. This indicates the order in which the object changed, with 1 being the oldest row. |
| OBJECT_LIBRARY | VARCHAR(10) | The name of the library that contains the object. |
| OBJECT_NAME | VARCHAR(10) | The name of the object under commitment control for the commitment definition. |
| OBJECT_TYPE | VARCHAR(7) | The type of object. |
| OPERATION | VARCHAR(42) | A description of the command or operation that caused a committable change to be made to the object. |
Example
- View all the objects associated with a given commit definition.
SELECT * FROM TABLE(QSYS2.DB_TRANSACTION_OBJECT_INFO('UDB_0100000000000001')) ORDER BY ORDINAL_POSITION;
