Aviso importante


  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos - +385


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 +385

   
 
  • Causa
    • ASSIGNMENT TO AN SQLSTATE OR SQLCODE VARIABLE IN AN SQL ROUTINE routine-name MAY BE OVERWRITTEN AND DOES NOT ACTIVATE ANY HANDLER

      SQL routine routine-name was created, but it contains an assignment statement that specifies the SQLCODE or SQLSTATE variable as the target.

      Assignment to an SQLSTATE or SQLCODE variable in an SQL routine only changes the value in the variable, and does not activate any handler.
      The SQLSTATE and SQLCODE variables are assigned values by processing of SQL statements in the SQL routine.
      Therefore, any value assigned might be over-written as a result of SQL statement processing.
  • Ação do sistema
    • The routine definition is processed successfully.
  • Resposta ao Desenvolvedor
    • No recovery is necessary.
      If the intent was to signal an error or warning, specify the SIGNAL or RESIGNAL statement instead of the assignment.

      To prevent the warning, remove any assignments to the SQLSTATE or SQLCODE special variables.

      SQLSTATE: 01643