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


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

   
 
  • Causa
    • stmt-verb object não pode ser executada porque function está sendo executada.

      The SQL statement could not be executed because the named function was executing at the time.

      stmt-verb     The type of data definition language (DDL) statement
      object          The DB2 object type
      function       A utility, the governor, or the distributed data facility (DDF)
      If the object is part of the communications database, it cannot be dropped while the DDF is active.
  • Ação do sistema
    • The statement was not executed.
  • Resposta ao Desenvolvedor
    • If the function is a utility, wait for the function to complete or stop.
      Then resubmit the statement for execution.

      If the function is the governor, the statement cannot be executed until the resource limit facility is stopped or switched to a different resource limit specification table (RLST).
      In a DB2 data sharing environment, the resource limit facility must be stopped on all members of the DB2 data sharing group or all members must switch to an RLST that is not associated with the object.

      If the function is the DDF, the facility must be stopped before the object can be dropped.
      In a DB2 data sharing environment, the facility must be stopped on all members of the DB2 data sharing group.

      SQLSTATE: 57005

© Copyright IBM Corp.