As shown in the table inDatatype conversion matrix, you can convert datatypes in the Integral Numeric category only to the following categories. Some mappings are allowed with a warning:
-
Integral Numeric
“Wide to narrow” mappings (for example, INTEGER to SMALLINT) are allowed with a warning, but source data is not truncated to fit a smaller target. In these cases, if the actual source column value is too long for the target column, rejection by the target DBMS is likely, resulting in replication or copy errors.
-
Character
The length of the receiving column must be equal to or greater than the length specified in the table below.
-
Decimal Numeric
The length of the receiving column must be equal to or greater than the length specified in the table below.
-
Approximate Numeric