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


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

   
 
  • Causa
    • AN OPERAND OF value IS NOT VALID.

      The operation value can be the LIKE predicate, the ESCAPE clause, the LOCATE scalar function, or the POSSTR scalar function.

      The following must be string expresions:
      • The operands appearing to the left of a LIKE or NOT LIKE predicate
      • The operand appearing in the ESCAPE clause
      • The first two arguments to the LOCATE function
      • The arguments to the POSSTR function

      See the for the rules of what can be specified in each context.

      A LIKE predicate, ESCAPE clause, LOCATE scalar function or POSSTR scalar function cannot be used with DATE, TIME, or TIMESTAMP.

  • Ação do sistema
    • Ação do sistema: The statement cannot be processed.
  • Resposta ao Desenvolvedor
    • Check and correct the syntax of LIKE, LOCATE, or POSSTR.

      SQLSTATE: 42824

© Copyright IBM Corp.