Return
-
Title
Sql Optimizer does not recognize (+1) on the sql statement -
Description
User optimized a SQL statement and got error: The Parser did not identify the text as a valid SQL statement.
[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "END-OF-STATEMENT" was found following " ". Expected tokens may include: "<table_expr>". SQLSTATE=42601 -
Cause
DB2 does not support ‘(+)’ format in SQL
-
Resolution
STATUS:
Enhancement request ST 83939 has been submitted to Development for consideration in a future release of Quest SQL Optimizer for DB2.
WORKAROUND:
None
-
Defect ID
CR83939