Ansicht
Dokumentation
SQL0160 - WITH CHECK OPTION not allowed for view &1 in &2. ( OS/400 )
Vendor Master (General Section) RFUMSV00 - Advance Return for Tax on Sales/PurchasesThis documentation is copyright by IBM.
Message : SQL0160
WITH CHECK OPTION not allowed for view &1 in &2.
Message Long Text :
Cause . . . . . : The WITH CHECK OPTION clause is not allowed in the CREATE VIEW statement for view &1 in &2 because the fullselect contains one of the following:
-- The first FROM clause identifies more than one table or view.
-- The first SELECT clause contains the DISTINCT keyword.
-- A UNION, EXCEPT, or INTERSECT was specified.
-- The outer subselect contains a GROUP BY clause.
-- The outer subselect contains a HAVING clause.
-- The outer subselect contains an aggregate function.
-- The outer subselect contains a UNION, EXCEPT, or INTERSECT.
-- All the select items in the outer subselect are expressions.
-- The SELECT statement contains a global variable.
-- The SELECT statement contains a scalar subselect.
-- The WITH CASCADED CHECK OPTION clause was specified and a view in the FROM clause contains a scalar subselect.
-- A special register or a function that is not deterministic, MODIFIES SQL DATA, or EXTERNAL ACTION is somewhere other than the outer select list.
-- A view in the FROM clause has an INSTEAD OF trigger defined on it.
Recovery . . . : Remove the WITH CHECK OPTION clause.
Message File : QSQLMSG
Library Message File : QSYS2924
BAL Application Log Documentation Addresses (Business Address Services)
This documentation is copyright by IBM.
Length: 3256 Date: 20240329 Time: 083542 sap01-206 ( 3 ms )