Ansicht
Dokumentation

SQL7057 - &1 was changed to PROGRAM TYPE MAIN. ( OS/400 )

SQL7057 - &1 was changed to PROGRAM TYPE MAIN. ( OS/400 )

BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL7057
&1 was changed to PROGRAM TYPE MAIN.

Message Long Text :

Cause . . . . . : An SQL procedure &1 in &2 has been changed from PROGRAM TYPE SUB to PROGRAM TYPE MAIN. The specific name of the procedure is &3. A PROGRAM TYPE SUB procedure is implemented using an ILE *SRVPGM, while a PROGRAM TYPE MAIN procedure is implemented using an ILE *PGM. The procedure call processing for an ILE *SRVPGM is faster than the procedure call processing for an ILE *PGM, so it is beneficial to create SQL procedures with the PROGRAM TYPE SUB option to achieve the best performance. If you see this message, it indicates that a procedure is being changed from PROGRAM TYPE SUB to PROGRAM TYPE MAIN on behalf of an ALTER PROCEDURE SQL statement or a RESTORE OBJECT (RSTOBJ) system command.
Recovery . . . : Either recreate the procedure using CREATE PROCEDURE or alter the procedure using the ALTER PROCEDURE SQL statement.

Message File : QSQLMSG
Library Message File : QSYS2924


ABAP Short Reference   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3218 Date: 20240329 Time: 095322     sap01-206 ( 2 ms )