Aviso importante


  C. A. Dornelles

SQL - SQLCODE's - Códigos positivos - +203


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 +203

   
 
  • Causa
    • THE QUALIFIED COLUMN NAME column-name WAS RESOLVED USING A NON-UNIQUE OR UNEXPOSED NAME

      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