SQL - SQLCODE's - Códigos negativos -592


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SQLCode -592

   
 
  • Causa
    • NOT AUTHORIZED TO CREATE FUNCTIONS OR PROCEDURES IN WLM ENVIRONMENT env-name.

      This mesage is issued when:
      • The value of the env-name token is 'NO WLM ENVIRONMENT' and the check for authorization to the DB2-managed stored procedures address space failed because the NO WLM ENVIRONMENT clause was specified on the CREATE PROCEDURE or ALTER PROCEDURE statement.
      • There is no DB2-managed stored procedures address space.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • To correct the error, perform one of the following actions:
      • If the value of the env-name token is 'NO WLM ENVIRONMENT', choose a different value for the WLM ENVIRONMENT keyword or request authorization to create objects in the specified WLM ENVIRONMENT from the system administrator.
      • If there is no DB2-managed stored procedures address space, request that one be created. Also request that a RACF PERMIT be completed to allow access to this resource.

      After doing one of the above, reissue the SQL statement.

      SQLSTATE: 42510

© Copyright IBM Corp.