I have some views that are using the ‘With’ clause and ER-Studio is giving me syntax error when I try to save it. It works fine in the database when I run the same query.
Error Message:
Syntax error near '(', line 2, column 9 -- This is where the 'with' clause starts.
This happened in both ER Studio 2016 and 2018. This is for a Netezza 7.0 model.