Thanks, Tom   Changing formats on the SAS side does not seem to work It seems that the number is too large, any value less than or equal to 999,999,999.9 gets inserted into the Teradata, any number larger and I get the error ... View more

After further investigation my question now is: How do I upload a value gt 999,999,999.9 to Teradata where the field is decimal(32,9)?   I either get the ERROR: On an insert, update, or index operation, the value applied to a Teradata 8 byte decimal was out of range - greater than 9.223372036854775808E18.   or ERROR: Teradata insert: Numeric overflow occurred during computation. ... View more

Hi   More information The limit_amt variable in Teradata is defined as  LIMIT_AMT DECIMAL(32,9) DEFAULT 0.000000000  COMPRESS ,   The limit that I'm trying to upload is 10917118759 The format in SAS is NAME TYPE LENGTH VARNUM LABEL FORMAT FORMATL FORMATD INFORMAT INFORML LIMIT_AMT 1 8 7   BEST 16 2 BEST 32   Lastly - the dataset on Teradata has been predefined and I don't have access to alter the definitions there ... View more