The following limitations apply to view definitions that specify set operators:
- UPDATE, DELETE, and INSERT are not applicable The following example does not work:
REPLACE VIEW V AS SELECT X FROM TABLE_1 UNION SELECT Y FROM TABLE_1; UPDATE V SET X=0;
An attempt to perform this sequence of statements produces the following error message:
***Failure 3823 VIEW 'v' may not be used for Help Index/ Constraint/Statistics, Update, Delete or Insert.
- WITH CHECK OPTION is not applicable The following example does not work:
REPLACE VIEW ERRV( c ) AS SELECT * FROM TABLE_1 UNION SELECT * FROM TABLE_2 WHERE TABLE_2.X=2 WITH CHECK OPTION;
An attempt to perform this statement causes the following error message:
***Failure 3847 Illegal use of a WITH clause.
- Column level privileges cannot be granted The following example does not work:
GRANT UPDATE ( c ) ON TABLE_VIEW TO USER_NAME;
An attempt to perform this statement causes the following error message:
***Failure 3499: GRANT cannot be used on views with set operators.
- A view definition that uses set operators cannot specify an ORDER BY clause, but a SELECT statement applied on the view can use ORDER BY.