2 Replies Latest reply: Oct 16, 2015 2:58 AM by Laura Sébille RSS

    Unable to use teradata functions

    Laura Sébille


      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