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


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

   
 
  • Causa
    • LABEL label SPECIFIED ON A GOTO, ITERATE, OR LEAVE STATEMENT IS NOT VALID.

      Label label is specified as the target label for a GOTO, ITERATE or LEAVE statement.
      label is not defined, is not defined in a scope that is accessible to the current statement, or to the current statement, or it is not a valid label for the failing statement.

      This error can occur with a GOTO, ITERATE or LEAVE statement for one of the following reasons:
      • If the failing statement is in a condition handler, then label must be defined in that condition handler.
      • If the failing statement is not in a condition handler, then label must not be defined in a condition handler.

      Additionally, this error can be issued for ITERATE or LEAVE statements for one of the following reasons:

      • If the failing statement is an ITERATE statement, then label must be defined as a label for a FOR, LOOP, REPEAT, or WHILE statement, and the ITERATE statement must be in that FOR, LOOP, REPEAT, or WHILE statement, or in a block of code that is directly or indirectly nested within that statement.
      • If the failing statement is a LEAVE statement, then label must be defined as a label for a compound, FOR, LOOP, REPEAT, or WHILE statement, and the LEAVE statement must be in that compound, FOR, LOOP, REPEAT, or WHILE statement, or in a block of code that is directly or indirectly nested within that statement.
  • Ação do sistema
    • The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Specify a valid label for the target of the GOTO, ITERATE, or LEAVE statement.

      SQLSTATE: 42736
© Copyright IBM Corp.