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


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

   
 
  • Causa
    • TYPE object-type) CANNOT BE REFERENCED EXPLICITLY OR IMPLICITLY

      The statement referenced an object, but the object cannot be used as requested.
      object-name
      The name of the referenced object.
      object-type
      The type of object that was referenced. Possible values include:
      VIEW
      An alteration was made to a table that underlies the object-name view, which caused the view definition to become invalid.
      The view must be successfully regenerated with an ALTER VIEW statement before it can be referenced in a statement other than ALTER VIEW, GRANT, REVOKE, DROP, COMMENT, or LABEL. Issue an ALTER VIEW statement to regenerate the view.
      ROW PERMISSION
      The object-name row permission is invalid because a previous attempt to regenerate it was unsuccessful.
      The row permission must be disabled before the row access control enforced table can be referenced.
      To correct the invalid state, the row permission must be dropped and re-created with a modified definition.
      COLUMN MASK
      The object-name column mask is invalid because a previous attempt to regenerate it was unsuccessful.
      The column mask must be disabled before the column access control enforced table can be referenced.
      To correct the invalid state, the column mask must be dropped and re-created with a modified definition.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Take the suggested corrective action.

      SQLSTATE: 51024

© Copyright IBM Corp.