Process spaces in the Expression Handler - 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

The Expression Handler has the following behavior relative to the processing of spaces:

  • VARCHAR data is retrieved and replicated with no editing done on any of the leading or trailing spaces that were updated into the original source data values.

  • You can insert in a VARCHAR data value, a string that is zero length.

  • For CHAR data (either EBCDIC, ASCII, or Unicode), the product generally, by default, trims all trailing spaces.

  • If a CHAR value is ALL spaces, then in general, the product retrieves and replicates 1 space as a “place holder” for this situation.