I have a decimal (17,2) field which has a default value of 999999999999999.99 (9(15).((2)). When mload'ing that data to teradata the value is being rounded to 1000000000000000.00 (1 followed by 15 0's.00) which is causing a decimal overflow error. Also the default value is being modified.
I tried the cast statement for similar data in TD and it did the same. The cast statements that I tried are as below:
select CAST
(999999999999999.99 as decimal(17,2)) as test ;
( 9(15).9(2) ) gives 1000000000000000.00 as output but,
select CAST
(99999999999999.99 as decimal(17,2)) as test;
( 9(14).9(2) ) gives 99999999999999.99 ( 9(14).9(2))
Please let me know if there is a way to have it mloaded as-is.