SAS BIGINT issue?

Third Party Software
Enthusiast

SAS BIGINT issue?

There is an issue with SAS 9 accessing Teradata databases that use BIGINT.

Error

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

Has anyone fixed this issue here? There was supposed to be a fix http://support.sas.com/kb/34/729.html has anyone had any success with this?

Random
1 REPLY
Enthusiast

Re: SAS BIGINT issue?

One workaround was to create views to cast the offending bigint to Decimal(31), but this has serious performance overheads.

Especially when the bigint is part of the Primary Key!

Your thoughts would be appreciated.

Random