Ansicht
Dokumentation

SQL0487 - SQL statements not allowed. ( OS/400 )

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


Message : SQL0487
SQL statements not allowed.

Message Long Text :

Cause . . . . . : One of the following errors has occurred:
-- A procedure was called or a function was invoked that was created with NO SQL specified as the data access attribute. A routine created with NO SQL, or any subsequent routines, cannot contain SQL statements and cannot invoke a routine that has the CONTAINS SQL DATA, READS SQL DATA, or MODIFIES SQL DATA attribute.
-- NO SQL cannot be specified when creating an SQL procedure or function.
-- A trigger containing SQL statements was activated.
-- The client SQL special registers cannot be changed within a procedure, function, or trigger.
-- A field procedure containing SQL statements was called.
If the error occurred in a procedure or function, the routine name is &1 and the specific name is &2.
Recovery . . . : Ensure routines created as NO SQL only invoke routines that do not contain SQL statements. Do not specify NO SQL for an SQL procedure or function. Do not change the client SQL special registers within a procedure, function, or trigger. Do not use SQL statements in a field procedure program.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3221 Date: 20240420 Time: 165403     sap01-206 ( 2 ms )