IQD 语法错误DMS-E-SS_SYNTAX, A syntax error was detected near 'XXX'.

TR0118 Transformer can't read the database <...> defined in <...>.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-SS_SYNTAX, A syntax error was detected near '<...>'

The Cognos UDA layer tries to interpret the SELECT order as if it was generated by Impromptu or Framework Manager, but the SQL statement contains a specific database function or syntax that is not recognized.

Inform the UDA layer that the request should be sent directly to the database by enclosing the whole statement into brackets {}

Steps:- Open the IQD file in a text editor
- Enclose the SQL statement into brackets like this :
...
BEGIN SQL
{SELECT ...
FROM ...
WHERE ...}
END SQL
...
- Save the IQD