BookmarkSubscribeRSS Feed
Gayle
Quartz | Level 8

Hi I am receiving error: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine

I am connecting to teradata here is the query below.  None of the attributes are bigint or anything they are char and int types.  I have cast the count(*) and I still receive the error

select * from connection to eabc(
select  hist_ky_add
		,cast(count(*)as int) as countuniq
from (select cast(cust_id as decimal(15,0)) as cust_id_test
	,cust_id 
	,cust_id_type 
	,cell_ky
	,rank(cust_id || cust_id_type || cast(cell_ky as varchar(16))asc)as hist_ky_add
from &crnttblname) a
group by 1
having count(*) > 1
);

Can you see what is wrong?  Any suggestions?

2 REPLIES 2
ChrisNZ
Tourmaline | Level 20

2 comments:
1. You can cast the other variables in turn to see which one causes the message. Or remove them from the query to perform the same test.
2. I am unsure SAS can read decimal variables. Why not an integer instead?

Gayle
Quartz | Level 8
thank you I had cast all of the variables before and gotten the same error , I may try that again. However, i did use this option:
OPTIONS SET=TRUNCATE_BIGINT YES ; and that got rid of the error

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 3003 views
  • 2 likes
  • 2 in conversation