When running a SQL Rewrite on a query where a comment exists after the FROM clause and it causes the following error:
[IBM][CLI Driver][DB2/AIX64] SQL0198N the statement string of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty. SQLSTATE=42617
Example query to cause the error:
Select *
From
--Table1 comment,
Table_2;
But if the comment is taken out, it rewrites fine.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center