'The Parser did not identify the text as a valid SQL statement' with "CONNECT BY PRIOR" (4269848)

Chat now with support

Return

Did this article solve an issue for you?

[Select Rating]

Title

'The Parser did not identify the text as a valid SQL statement' with "CONNECT BY PRIOR"
Description

Customer tried to optimize
SELECT NAME
   FROM EMP9
   START WITH NAME = 'Goyal'
   CONNECT BY PRIOR EMPID = MGRID
and got error 'The Parser did not identify the text as a valid SQL statement.
Resolution

STATUS:
Waiting for IBM/DB2 to support CONNECT BY PRIOR on db2expln
WORKAROUND:
None

Did this article solve an issue for you?

[Select Rating]

Title