Ansicht
Dokumentation

SQL9015 - Program or service program &1 restored but not created as SQL object &3 in &2. ( OS/400 )

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : SQL9015
Program or service program &1 restored but not created as SQL object &3 in &2.

Message Long Text :

Cause . . . . . : Program or service program &1 was restored to library &2, but could not be created as an SQL procedure, function.or global variable. The program or service program was initially created as a result of the CREATE PROCEDURE (SQL) command, created as a result of the CREATE FUNCTION (SQL) command, marked as a result of the CREATE PROCEDURE (external) command, marked as a result of the CREATE FUNCTION (external) command, or created as a result of the CREATE VARIABLE (SQL) command. The attempt to add the SQL procedure or function to the SQL catalogs SYSROUTINES and SYSPARMS failed or the attempt to add the SQL variable to the SQL catalogs SYSVARIABLES and SYSVARIABLEDEP failed. Possible reasons are:
-- The procedure or function already exists with the same specific name as &3 in &2.
-- A global variable already exists with the same name as &3 in &2.
-- The SQL procedure is compiled with ALLOW DEBUG MODE.
-- The service program is an SQL global variable and was restored, copied or moved to the library QTEMP, QSYS, QSYS2, SYSIBM, or SYSPROC.
Recovery . . . : If the program or service program is a procedure or function, ensure the procedure name and library name are unique for the program being restored. Create an SQL procedure without ALLOW DEBUG MODE specified before restoring to a different library.
If the service program is an SQL global varaible and the global variable name &3 is not the same as the service program name &1 you may still be able to reference the global variable using the name &1. Restore, move or copy the global variable into a different library.

Message File : QSQLMSG
Library Message File : QSYS2924


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

Length: 3270 Date: 20240419 Time: 034625     sap01-206 ( 3 ms )