Hi,
in a DWH like environment I'm monitoring a DWH database. Some warnings about long running statements pop up and when I try to open these warnings, I get following error message:
Statement could not be formatted due to a syntax error. Please, validate your statement first.
Error code 9, from line 1 col 1047 to line 1 col 2498 (offset 1046 to 2497), msg text: ")" inserted to complete scope Error code 9, from line 1 col 823 to line 1 col 2498 (offset 822 to 2497), msg text: ")" inserted to complete scope Error code 9, from line 1 col 807 to line 1 col 2498 (offset 806 to 2497), msg text: ")" inserted to complete scope Error code 9, from line 1 col 807 to line 1 col 2498 (offset 806 to 2497), msg text: "JOIN <joined_table>" inserted to complete scope Error code 10, from line 1 col 2480 to line 1 col 2498 (offset 2479 to 2497), msg text: "EOF_TOKEN" reached after this token
Sometimes DMC shows the statement, sometimes it doesn't.
Kind regards
Roland
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
Muenchen
------------------------------
#Db2