SELECT Failed. 3706: Syntax error: Data Type "response_tm_sec" does not match a Defined Type name.

Database

SELECT Failed. 3706: Syntax error: Data Type "response_tm_sec" does not match a Defined Type name.

Hi,

I'm getting the "SELECT Failed. 3706: Syntax error: Data Type "response_tm_sec" does not match a Defined Type name." error when I run the following SQL on SQL Assistant:

select min(response_tm_sec) min_response_tm

, average(response_tm_sec) avg_response_tm

, max(response_tm_sec) max_response_tm

--, stdev(response_tm_sec) stdev_response_tm

from s_csd.mbenger_2013_RT_cases

where response_tm_sec is not null

;

However, if I comment the stdev line, the query works and gives me a result for max, min and averages. The response_tms_sec is a decimal type (18,8). It shows up like this with the help command:








Column Name Type Nullable Format Max Length Decimal Total Digits Decimal Fractional Digits
response_tm_sec                D  Y -0.999999 8 18 6

I get this column b extract the hour, minute and seconds(with 6 fractional digits) out of an interval type and multiplying and adding to get the figure in seconds.

I saw on another post that this may have to do with ODBC functions. I went into Tools -> Options -> Query to "Allow ODBC Functions" but no such options was present.

I use Teradata Database Version 13.10.0509 13.10.05.09 and Provider Version ODBC 13.10.00.06 and Client 13.10

I did do a bit of search about this kind of error but none of the options I came upon dealt with tis problem happening with decimal data types and the solutions didn't work.

Thanks in advance for your help

1 REPLY
Junior Contributor

Re: SELECT Failed. 3706: Syntax error: Data Type "response_tm_sec" does not match a Defined Type name.

The error message is misleading, there's no stdev function, it's called STDDEV_POP or STDDEV_SAMP :-)

Dieter