Aginity workbench for Netezza does not give syntax error for large queries

I have noticed several times that running Netezza queries which are long (in terms of code length not performance) and syntactically wrong does not provide a well defined error message in Aginity and just gives a catchall error (ERROR 42000). Is there a way to get the exact error which causes the code to fail (as in Oracle) for large queries?

Solution

You may find that the error message is truncated from the end of the string returned using the ODBC driver with Aginity. Try using the OLE-DB driver when connecting with Aginity instead, as I have found it to retain the full error text from larger queries.

"Expecting member declaration"
jni compile with cl compiler has syntax error, but not relevant
Why am I getting a "cannot find symbol" when I compile?
syntax error while compiling with ifort 11.0
Why do I get "SyntaxError: invalid syntax" in a line with perfectly valid syntax?
Xcode 14.2 Play Sound Error:AddInstanceForFactory: No factory registered for id <CFUUID
Syntax error at end of input in PostgreSQL
Why does the typo {$ block content %} cause an error?
Syntax error: Illegal return statement in JavaScript
The requested module '' does not provide an export named 'default'
Is there a syntax error in this iCalendar event code?
Ghostscript unrecoverable error undefinedfilename
Python: SyntaxError: EOL while scanning string literal
Moving LENGTH OF to a COMP field fails parse
JS works embedded in Flask template, but not in separate file
Use of GROUP_CONCAT() results in error 1064
How to pass parameters to task from file
Syntax error , insert "EnumBody" to complete EnumDeclaration
JSON syntax error: 'unexpected number' or 'JSON.parse: expected ',' or '}' after property value in object'
Syntax error at input 'end of line without line continuation', Pine Script, TradingView
How can I construct an object with keys that contain hyphens?
getting syntax error for & sign that does not exist in VS Code
Visual Studio displaying errors even if projects build
Cannot generate random uuid syntax error at or near uuid_generate_v4
SQL46010 Syntax Error when creating a stored procedure in Visual Studio 15
SyntaxError when importing Tensorflow on a mac
How to use line breaks in PowerShell Method-Chaining
An object key of a class isn't initialized or assigned in the constructor. Why does quoting it mute the error?
VSCode extensions "GLSL Lint" and "glsl linter" don't find errors with .frag code even when there are problems
Chrome: Uncaught SyntaxError: Unexpected end of input