Is there a Toad for DB2 limitation with CREATE OR REPLACE VIEW and the parser? Toad gives a parser error message "Incorrect syntax near 'OR' ".
"Create or Replace View" is a new feature of DB2 v9.7. Parser does not recognize the "create or replace" as valid syntax.
WORKAROUND:
This issue should not cause any disruption in the sql statement running.
STATUS:
Waiting for fix in a future version of Toad for DB2.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center