Convert null to tilde character - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-08-20
ft:lastPublication
2024-08-20T21:40:14.000381

Method:   Convert null to ~

Function name:   null2td

Parameter list:   (CHAR input)

Return type:   CHAR

What the method does:    For character datatypes only. Sends NOT NULL source column values exactly as they are (byte-to-byte) to the target columns. If a source column is NULL, sends a tilde character (~) to the target column. The argument must be an SQL column.