Aviso importante
Caso tenhas alguma
dúvida a respeito
da linguagem mande
um e-mail que terás
a resposta.
C. A. Dornelles
SQL - SQLCODE's - Códigos positivos
Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF.
SQLCode +203
THE QUALIFIED COLUMN NAME
column-name
WAS RESOLVED USING A NON-UNIQUE OR UNEXPOSED NAME
Causa:
The table designator selected to resolve a qualified column name is one of the following:
An unexposed name
An exposed name that has an exposed duplicate in the same FROM clause
An exposed name that has an unexposed duplicate which appears before the selected name in the ordered list of names to which the qualifier is compared
Therefore, the statement does not conform to the guidelines for using only unique exposed names as qualifiers or it is possible that the column reference was not resolved to the intended instance of the table or view.
Ação do sistema:
DB2 uses the selected name to resolve the reference.
Resposta ao Desenvolvedor:
If DB2's resolution of the qualifier was not what you intended, rewrite the SQL statement and submit it again. The rules used to resolve column name qualifiers are given in Chapter 2 of
DB2 SQL Reference
.
SQLSTATE: 01552