Ansicht
Dokumentation

SQL799B - &3 for routine &1 completed, but cannot be saved and restored. ( OS/400 )

General Material Data   General Data in Customer Master  
This documentation is copyright by IBM.


Message : SQL799B
&3 for routine &1 completed, but cannot be saved and restored.

Message Long Text :

Cause . . . . . : A COMMENT or LABEL was added to routine &1 in &2 but the comment or label could not be saved in the associated program or service program object. If the *PGM or *SRVPGM object is saved and then restored, the SQL catalogs will not be updated with the comment or label for this routine. Reason code is &4. Reason codes and their meanings are:
1 -- The external program did not exist when the COMMENT ON or LABEL ON statement was issued or it did not exist when the routine was created.
2 -- The external program schema is QSYS.
3 -- The external program was not an ILE *PGM or *SRVPGM.
6 -- The SQL associated space in the external program could not be expanded.
7 -- The external program was compiled in a release prior to V4R4M0.
9 -- The external program is not in the same Independent ASP (IASP) as the routine.
Recovery . . . : Do one of the following based on the reason code:
1 -- Ensure that the external program exists when the routine is created and when the COMMENT ON or LABEL ON statement is issued.
2 -- Ensure that the external program schema is not QSYS.
3 -- Ensure that the external program is an ILE *PGM or *SRVPGM.
6 -- Try recompiling the external program to rebuild the program's associated space.
7 -- Recompile the external program in a more recent release.
9 -- Ensure the external program is in the same IASP as the procedure.

Message File : QSQLMSG
Library Message File : QSYS2924


CPI1466 during Backup   General Material Data  
This documentation is copyright by IBM.

Length: 3268 Date: 20240424 Time: 055305     sap01-206 ( 2 ms )