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


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

   
 
  • Causa
    • STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID.

      Uma das seguintes situação ocorreu:
      • The statement refers to multiple locations.
      • A statement with a remote reference is being EXPLAINED either by a dynamic EXPLAIN statement or the EXPLAIN(YES) option.
      • An alias is used incorrectly.
      • A three-part name is implicitly or explicitly used in a statement that is not supported by the DB2 private protocols.
      • A three-part name is implicitly or explicitly used in a triggered statement.
      • A PREPARE statement contains an ATTRIBUTES clause. This is not supported by the BD2 private protocols.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • If the object cannot be meaningfully eliminated from the statement, see your Database Administrator for other ways to obtain the data required.
      Refer to Chapter 3 of DB2 SQL Reference for more information about using remote objects.

      If the remote object reference is in a triggered SQL statement, you can instead invoke a user-defined function or a stored procedure from the trigger and access the remote object from the function or stored procedure.

      SQLSTATE: 56023

© Copyright IBM Corp.