Return
-
Title
Get 'parser did not identify the text...' and SQL0198N errors optimizing statement -
Description
The following errors are received when attempting to optimize a sql statement.
1) 'The parser did not identify the text as a valid SQL statement.'
2) [IBM][CLI Driver][DB2] SQL0198N The statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. SQLSTATE=42617 -
Cause
The problem is caused by the "@" in a schema name. For example, XXXX@ -
Resolution
RESOLUTION #1:
Double quote the schema and table name. For example, "XXXX@"."TABLE".
RESOLUTION #2
a) Close SQL Optimizer for DB2 z/OS
b) Backup this file:
C:\Program Files (x86)\Dell\Quest SQL Optimizer for DB2 zOS 5.5\QDB2OptEngLib.dll
c) Place QDB2OptEngLib.dll in attached ZIP file to this folder:
C:\Program Files (x86)\Dell\Quest SQL Optimizer for DB2 zOS 5.5\
d) Start SQL Optimizer for DB2 z/OS and try again.
STATUS:
Waiting for a fix to defect ID 'SOFDZ-501' to be implemented in a future version of SQL Optimizer of z/OS. -
Defect ID
SOFDZ-501 -
Attachments