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.

Read syntax diagramSkip visual syntax diagramDB_TRANSACTION_OBJECT_INFO( LOCK_SPACE_ID =>  lock-space-id )
The schema is QSYS2.
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.

Table 1. DB_TRANSACTION_OBJECT_INFO table function
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;