System Variable: Transaction Timestamp - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

Variable

What you see in omnient.ini

Replacement value

Recommended target column type

Transaction Timestamp

sv_trans_timestamp

For log-based Change Selectors, returns the transaction commit timestamp. Time is GMT, including fractions of a second

For a trigger-based Change Selector, returns the time of the transaction’s last update captured for replication.

VARCHAR(20)