Hi,
Customer is migrating from 11.5 to 12.2. They found the bahvior changes according to the 'MigrationBehaviorChanges.pdf'.
Conversion between different data types
For this release, there is a change in behavior for data conversion between
different data types. Previously, if an error occurred during data conversion
(for example when converting a varchar string to an integer, the varchar string
contains non-digits), the result was random. Now, the return value will be
NULL for any unsuccessful conversion.
Previously Data Integrator returned random data for the result of a varchar to
datetime conversion when the varchar string contains an illegal date format.
Now, the return value will be NULL.
May I know anyway that we can set DS12.2 to funciton same as 11.5 in the data type conversion?
thanks and regards
nora