topic Re: Unable to use teradata functions in QlikView

Unable to use teradata functions

Thu, 15 Oct 2015 17:15:59 GMT

Hello everyone,

I have just moved from one server to another.

I use an ODBC connection to connect to a teradata database.

On my new server, I get an error each time I use an SQL teradata function in the script.

For example, in my sql statetement, if I do SELECT Somedate, ... it works

But If I do SELECT DATE(Somedate) or MONTH (Somedate), I get the error " Syntax error : Data Type "Somedate" does not a Defined Type name."

Maybe it comes from the ODBC configuration ?

Or do I have to configure something in QV ?

As I said, the application worked on my previous server..

Thank you for your help

Laura

nagaiank — Thu, 15 Oct 2015 17:26:38 GMT

If the Teradata functions are in a SQL statement, did you use the SQL prefix?

SQL (valid SQL SELECT statement with Teradata SQL functions)

Fri, 16 Oct 2015 06:58:50 GMT

I did.

As I said, the application worked on my previous server