Ansicht
Dokumentation

SQL0160 - WITH CHECK OPTION not allowed for view &1 in &2. ( OS/400 )

SQL0160 - WITH CHECK OPTION not allowed for view &1 in &2. ( OS/400 )

Vendor Master (General Section)   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.
SAP E-Book


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 )