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


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 -807

   
 
  • Causa
    • ACCESS DENIED: PACKAGE package-name IS NOT ENABLED FOR ACCESS FROM connection-type connection-name

      Access is denied for one of the following reasons:

      • It is disabled, either from the 'connection-type' or from the 'connection-type' with the specific 'connection-name'.
      • The attach library that you are using is from a previous release of DB2 that does not support the ENABLE and DISABLE options of the bind operation.

      The variables are:

      package-name
      The package name (collection.package-id).
      connection-type
      One of the following: BATCH, DB2CALL, REMOTE, IMSBMP, IMSMPP, CICS, DLIBATCH, or UNKNOWN.
      connection-name
      Name of the connection that is restricted.
      If all connection names from a specific connection-type are restricted, this value is not specified.
  • Ação do sistema
    • The statement is not executed and the package is not allocated.
  • Resposta ao Desenvolvedor
    • One of the following:
      • Rebind the package to enable it to execute with the required connection type and name.
      • Check the SYSPLSYSTEM or SYSPKSYSTEM catalog table to find a connection from which the package can be executed.
      • Correct the attach library.

      SQLSTATE: 23509
© Copyright IBM Corp.