Teradata | Bigint to decimal

[librasonali]

Hi Team,

I have one query i m running below in SAS EG  , it is giving me below error : I noticed that KEY is in BIG INT. does Teradata doesn't support BIG int shd I cast the field into decimal ?

41 );
ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine.

[LinusH]

SAS/ACCESS (and SAS in general) doesn't support this data type.

So yes, cast to a supported data type.

If values are too big for decimal, an option is to cast to CHAR (probably ok if it's used for id ad not calculations). 

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0v7nh4ylrihtin1te8xl0q3dvzv.htm

[yabwon]

Did you test DBSASTYPE= dataset option?

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0v4ma1zb9lu99n1728j279rjcqi.htm

Bart

[yabwon]

Here is also one more resource:

https://support.sas.com/kb/39/831.html

B.