All Forums Connectivity
M..S 2 posts Joined 09/11
30 May 2012
Using != throws an error in [TeraJDBC]

As per subject, really.  Got a simple query:

SELECT * FROM dbc.databases WHERE databasename != 'foo'

When I try and run it through the JDBC connection I get the error:

[Teradata Database] [TeraJDBC] [Error 3707] [SQLState 42000] Syntax error, expected something like an 'IN' keyword or a 'CONTAINS' keyword between the word 'databasename' and '|'.

Workaround would appear to be use <> instead of !=

ulrich 816 posts Joined 09/09
30 May 2012

not related to JDBC



feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.