Update DML handler
To verify the extra attributes included,
the following SQL can be used:
DNYTST10
SQL>@show_capture_extra_attrib
Capture Process Attribute Name
Include Attrib in LCRs
-------------------- ---------------
-----------------------
NY4_CAPTURE THREAD# NO
NY4_CAPTURE ROW_ID NO
NY4_CAPTURE SESSION# YES
NY4_CAPTURE SERIAL# NO
NY4_CAPTURE USERNAME YES
NY4_CAPTURE TX_NAME YES
6 rows selected.
Next, the transaction name at source
database is set before an update operation is executed. In the
following example, the transaction name is set to my_txn10:
DNYTST10 SQL>SET TRANSACTION NAME
'my_txn10' ;
Transaction set.