Ansicht
Dokumentation

SQL0577 - Modifying SQL data not permitted. ( OS/400 )

CL_GUI_FRONTEND_SERVICES - Frontend Services   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : SQL0577
Modifying SQL data not permitted.

Message Long Text :

Cause . . . . . : One of the following errors has occurred:
-- A procedure was called or a function was invoked that was created with READS SQL DATA or CONTAINS SQL DATA specified as the data access attribute. A procedure or function created with READS SQL DATA or CONTAINS SQL DATA, or any procedure or function that is called by the procedure or function, cannot change data and cannot call a procedure or function that has the MODIFIES SQL DATA attribute.
-- READS SQL DATA and CONTAINS SQL DATA cannot be specified on the CREATE PROCEDURE, ALTER PROCEDURE, CREATE FUNCTION or ALTER FUNCTION statements for an SQL procedure or function if the routine body contains statements that change data.
-- A BEFORE trigger was activated that contains statements that change data.
Statements that change data include INSERT, UPDATE, DELETE, MERGE, REFRESH TABLE, GRANT, REVOKE, LABEL, COMMENT, and any CREATE, DROP or ALTER statements. If the error occurred in a procedure or function, the routine name is &1 and the specific name is &2.
Recovery . . . : Ensure procedures or functions created with READS SQL DATA or CONTAINS SQL DATA do not call procedures or functions that change SQL data. Specify MODIFIES SQL DATA when creating functions that change SQL data.

Message File : QSQLMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3223 Date: 20240425 Time: 084955     sap01-206 ( 2 ms )