Functions doesn't work with the ODBC connection

Connectivity
Fan

Functions doesn't work with the ODBC connection

Hello everyone,

I have lately install an ODBC connection on a new server that we have set up.

I connect to the database through Qlikview (a datavisualisation tool), it works well except when I want to use a teradata function.

For example:


I get a syntax error. I've tried with several functions and always get a syntax error... Of course, I have checked the SQL query was ok and it is !

Do you have any ideas ?

Tags (1)
3 REPLIES
Fan

Re: Functions doesn't work with the ODBC connection

For example, if I do:

SELECT
DEVT as MyMonth, LADRURL,CIDENTACCES,CCLI
FROM vevtnet

It works well.

But if I do :

 Select 

MONTH(DEVT) as MyMonth, LADRURL,CIDENTACCES, count(CCLI) as nb 
from vevtnet
group by 1,2,3

Then I get a syntax error. Each time I use a function.

Whereas the query works when I use it on another server.

Senior Apprentice

Re: Functions doesn't work with the ODBC connection

MONTH is an ODBC function which is rewritten to valid Teradata SQL by the ODBC driver if the "Disable Parsing" option has not been checked and the query is a DML statement. 

So either set this option or better write correct SQL :-)

EXTRACT(MONTH FROM DEVT)

Fan

Re: Functions doesn't work with the ODBC connection

Thank you for your answer Dieter.

The "Disable Parsing" option wasn't checked so it was supposed to work if I use the "month" function ?

I have tried

 Select 

EXTRACT(MONTH FROM DEVT) as MyMonth,
 LADRURL,CIDENTACCES, count(CCLI) as nb 
from vevtnet

group by 1,2,3
;

And I get the error "didn't find the "DEVT" field" ...