Decimal numeric category - connect_cdc_mimix_share - Latest

You can convert datatypes in the Decimal Numeric category to datatypes in the Decimal Numeric, Character, Integral Numeric, and Approximate Numeric categories.

You cannot convert datatypes in the Decimal Numeric category to datatypes in the Date, Interval, Binary, or Other categories.

As an example, in the mapping DEC(3,2) to character, the target needs to be a minimum of 5 characters (that is, CHAR(5) ) to accommodate the maximum size of the data that can be sent. This includes the sign, the decimal point, and the precision and scale:

-n.nn

For other information on how truncation is handled in a decimal, see Data Handling.

See Decimals for information on how the Expression Handler deals with decimals.

The supported Decimal Numeric datatype mappings are shown in the table below. DBMSs are abbreviated in the table as follows:

Connect CDC has two binary categories: Binary and Long Binary. Datatypes designed for large binary objects belong to the Long Binary category.

Binary type columns in any DBMS cannot be used in data enhancement, expressions or gate conditions.