Code row timestamp to return a value other than a zero-length string - 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

Use the following syntax to return a value other than the default zero-length string:

begin returns char;
    /* for copy this returns a 0-length string but one might not always find this acceptable */
   if (iscopy())
        /* return whatever valid date string one wants -         current timestamp for copy will do */
       return current_timestamp();
   else
       return rowoptimepunc();
end;