can't understand why ERROR: At least one of the columns in this DBMS table has a datatype that is no

[Gayle]

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?

[ChrisNZ]

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]

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