topic Teradata | Bigint to decimal in SAS Programming

Teradata | Bigint to decimal

librasonali — Wed, 23 Feb 2022 07:23:08 GMT

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.

Re: Teradata | Bigint to decimal

LinusH — Fri, 18 Feb 2022 12:21:22 GMT

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

Re: Teradata | Bigint to decimal

yabwon — Fri, 18 Feb 2022 12:46:04 GMT

Did you test DBSASTYPE= dataset option?

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

Bart

Re: Teradata | Bigint to decimal

yabwon — Fri, 18 Feb 2022 12:47:53 GMT

Here is also one more resource:

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