topic Re: can't understand why ERROR: At least one of the columns in this DBMS table has a datatype that i in SAS Programming

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

Gayle — Fri, 26 Feb 2021 15:23:59 GMT

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?

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

ChrisNZ — Sat, 27 Feb 2021 07:13:28 GMT

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?

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

Gayle — Thu, 04 Mar 2021 04:53:10 GMT

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