All Forums Third Party Software
Random_Thought 87 posts Joined 06/09
12 Nov 2009
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

Random_Thought 87 posts Joined 06/09
12 Nov 2009

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

You must sign in to leave a comment.