Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Unable to use teradata functions


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

2 Replies
nagaiank
Valued Contributor III

Re: Unable to use teradata functions

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

SQL  (valid SQL SELECT statement with Teradata SQL functions)

Not applicable

Re: Unable to use teradata functions

I did.

As I said, the application worked on my previous server

Community Browser