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


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 -171
   
 
  • Causa
    • O tipo de dado, comprimento ou valor do argumento nn da function-name é inválido Either the data type, the length or the value of argument nn of scalar function function-name is incorrect.

      If the encoding scheme is EBCDIC or ASCII, a possible reason for this error is that a character argument was specified for a built-in function that expects a graphic argument, or a graphic argument was specified for a built-in function that expects a character argument.
      The UNICODE encoding scheme does support the mixing of character and graphic arguments.
  • Ação do sistema
    • The statement cannot be executed.
  • Resposta ao Desenvolvedor
    • Correct the statement.
      Refer to Chapter 3 of DB2SQL Reference for rules for each argument of the scalar function function-name.

      SQLSTATE: 42815

© Copyright IBM Corp.