Menu principal                 [Fechar]


SQL - SQLCODE's - Códigos negativos


Volta a página anterior

Volta ao Menu Principal


Desenvolvido por Carlos Alberto Dornelles - Analista de Sistemas - Brasília DF.


SQLCode -180

Sintaxe inválida para DATE, TIME OU TIMESTAMP

Conclusão: O tamanho ou string representando um DATE, TIME ou TIMESTAMP value não está conforme os formatos válidos.

The value can contain one of the following:

  • For a host variable, the position number of the input host variable. If the position number cannot be determined, a blank is displayed.

  • For a character string constant, the character string constant. The maximum length that is displayed is the length of SQLERRM.

  • For a character column, the column name. If the column is a VIEW column and it has a corresponding base column, the VIEW column name is displayed. If the column is a VIEW column but it does not have a corresponding base column, a string of '*N' is displayed.

Otherwise, value is a string of '*N'.

Ação do sistema: O comando não pode ser executado.

Resposta ao Desenvolvedor: Correct the program to ensure the specified value conforms to the syntax of DATE, TIME, and TIMESTAMP. Refer to Chapter 2 of DB2 SQL Reference for a list of valid DATE and TIME formats.

SQLSTATE: 22007


© Copyright IBM Corp.