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


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

   
 
  • Causa
    • variable-name IS AN UNDEFINED OR UNUSABLE HOST VARIABLE OR IS USED IN A DYNAMIC SQL STATEMENT OR A TRIGGER DEFINITION

      The host variable variable-name appears in the SQL statement, but:
      • The SQL statement is a prepared statement, or
      • The attributes of the variable are inconsistent with its usage in the static SQL statement, or
      • The variable is not declared in the application program or
      • The variable appeared in one of the triggered SQL statements in a CREATE TRIGGER statement.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Verify that
      • The variable name is spelled properly in the SQL statement.
      • The variable is allowed in the SQL statement.
      • The application program contains a declaration for that variable.
      • The attributes of the variable are compatible with its use in the statement.

      SQLSTATE: 42618

© Copyright IBM Corp.