Ansicht
Dokumentation

CPD434C - Cannot create this view using the WITH CHECK OPTION parameter. ( OS/400 )

ROGBILLS - Synchronize billing plans   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.


Message : CPD434C
Cannot create this view using the WITH CHECK OPTION parameter.

Message Long Text :

Cause . . . . . : The definition of the SQL view file that was specified on the CREATE VIEW statement conflicts with the WITH CHECK OPTION that was also specified. The reason is one of the following:
-- The view is read-only,
-- The view contains a function that is not deterministic and is used in the WHERE clause, or
-- The view specifed the WITH CASCADED CHECK OPTION and an underlying view contains a subselect.
-- The view contains a special register in other than the outer select list of the view.
-- The view contains a global variable.
Recovery . . . : If the view being created is read-only, then the WITH CHECK OPTION cannot be specified. If an underlying view contains a subselect, only the WITH LOCAL CHECK OPTION parameter is valid. Functions that are not deterministic may not be used in the WHERE clause of views that specify the WITH CHECK OPTION. Change the parameters on the CREATE VIEW statement and try the request again.

Message File : QCPFMSG
Library Message File : QSYS2924


General Material Data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3254 Date: 20240419 Time: 180303     sap01-206 ( 2 ms )