Return
-
Title
SQL Scanner is unable to scan the complete list of SQL statements -
Description
SQL Scanner is unable to retrieve SQL statements from packages starting with DECLARE CURSOR like the following:
DECLARE TASKS1 CURSOR FOR SELECT TASKID
FROM SYSTOOLS.ADMINTASKS
WHERE NAME = :H00048 -
Cause
Product defect
-
Resolution
WORKAROUND
Contact Quest Support to retrieve the patch.
STATUS
Waiting for fix in a future release of Quest SQL Optimizer for DB2.
-
Defect ID
ST91723, ST91724