Transaction timestamp with punctuation - Connect_CDC - connect_cdc_mimix_share - 5.8

Connect CDC System Reference 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 System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Method:   Transaction timestamp with punctuation

Function name:   trantimepunc

Parameter list: none

Return type:    CHAR

What the method does: The implied input is the current data row.    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.

“trantimepunc” should be used if the target column is a timestamp. The format is:

yyyy-mm-dd hh:mm:ss.ffffff

and, therefore, is suitable for mapping to timestamp/date/time columns in addition to character columns.

The source of this data is not a column but a field in the log record or the time recovered from a stored procedure and is always maintained as a character string.

If a Copy request, sends a zero-length string. To see an example of how to code an expression to return a different value than the default, see  Code row optype to return a value other than a zero-length string and Code row timestamp to return a value other than a zero-length string.

Note: All 6 digits (for System i5 and SQL Server) contain fractional digits that are accurate to 6 digits. Other databases fractional digits may be padded with up to 6 zeros so that all timestamps for all databases total 20 digits.