DB2 set date to null - 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:   DB2 set date to null

Function name:   de_DB2date_to_NULL

Parameter list:   (CHAR input)

Return type:   CHAR

What the method does:    Convert DB2 dates with the value of 0001-01-01 (or 00010101) to a NULL> Other values are unaffected and the method just returns the date unchanged.