Get "The Parser did not identify the text as a valid SQL statement" error showing plan or rewriting SQL (4249175)

Chat now with support

Return

Title

Get "The Parser did not identify the text as a valid SQL statement" error showing plan or rewriting SQL
Description

When showing the plan or rewriting SQL for a query that contains a comment in the SQL body, the following error is received.

"The Parser did not identify the text as a valid SQL statement"
Here is an example of SQL that gets the error:
SELECT T.TABSCHEMA, T.TABNAME, T.CREATE_TIME, T.ALTER_TIME, I.INDNAME, I.COLNAMES, I.CREATE_TIME
FROM SYSCAT.TABLES T
INNER JOIN SYSCAT.INDEXES I
-- COMMENT
ON (T.TABSCHEMA, T.TABNAME) = (I.TABSCHEMA, I.TABNAME)
WHERE T.TABSCHEMA = 'SYSIBM'
AND T.TABNAME = 'SYSTABLES'
WITH UR

Sign In Required

You need to be signed in and under a current maintenance contract to view premium knowledge articles.