Truncation

Bisection of a DBCS character may occur during an assignment operation of a character string since it may be a mixed string. When such bisection occurs, the fragment byte of the bisected DBCS character will be replaced with an SBCS blank. The following is an example of a column data of 7 byte length assigned to a host-variable of 5 byte length:

original column data:     abD1D2c
                             |
                             V
intermediate result:      abD1D
                             |
                             V
result in host variable:  abD1#
                          ('#' denotes an SBCS blank.)

See String Manipulation for general discussions on string manipulation.

Note:

• The fragment byte caused by truncation during an assignment operation will be replaced with an SBCS blank even if FOR BIT DATA is specified for the column.

• Bisection may also occur in SUBSTR function. However, the fragment byte(s) will be left as it is.