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

THE LOCALE locale SPECIFIED IN A SET LOCALE OR OTHER STATEMENT THAT IS LOCALE SENSITIVE WAS NOT FOUND

Conclusão: The statement attempted to reference a Locale that is not known or not available to DB2. locale is the locale that was either specified on the SET CURRENT LOCALE statement or the locale that was in effect at the time the Locale access was attempted.

Ação do sistema: The statement cannot be executed.

Resposta do Desenvolvedor: If the statement was a SET LOCALE statement, re-specify a locale that is correct (known and available to DB2).
Refer to Chapter 3 of SQL Reference for more information on Locales.
If the statement was something other than SET LOCALE, then the statement contained a locale sensitive interface (the UPPER function is an example of a locale sensitive interface).
Issue "SELECT CURRENT LOCALE FROM SYSIBM.SYSDUMMY1" to determine the value of the LOCALE in use by your program.
Possible reasons for this message include an incorrect LOCALE bind option, or an incorrect LOCALE default value specified at installation time (The value of a Locale is not validated until it is needed in a Locale sensitive interface).
Because Locales are dynamic in nature, they can be added, created, or deleted at anytime, they are not validated until they are used.
Therefore, it is possible to specify a locale that is not valid at installation or bind time.

SQLSTATE: 42708


© Copyright IBM Corp.