Expert: Jean-Pierre Zuate - 12/18/2006

Question
Hello, Jean Pierre.
I can't handle one error because errno neither dbmserror returns its code. The error is:
E_PS0461 A <column reference> contained a <qualifier> 'm'    
   which did not correspond to any of the <table reference>s.
Do you know what can i do?
Thanks.
   within whose scope the <column reference> appeared.  

Answer
Hello Miguel,

First of all, you can find help with error messages from two way :
- in the directory II_SYSTEM ($II_SYSTEM on linux/unix or %II_SYSTEM% on windows) there is always the following ingres\sig\errhelp. In this directory you have a small utility that provide the complete message (but in your case it did not help)
- in the directory $II_SYSTEM\ingres\ingres\files\english\messages you can find a file named messages.txt and sometimes there is here an explanation for some error message

In your case you reference a column with an incorrect qualifier. "qualifiers" are the name of a table has it is mentionned in the FROM clause of your query. For example :
FROM my_table t, my_second_table t2. t & t2 are the qualifiers. If you do not specify thoses aliases, ingres use the name of the table.

The misuse of the qualifier can appears in :
- column list (select clause)
- having clause
- group by clause
- where clause
- check constraint

The text in messages.txt is the following :
E_PS0461_BAD_COL_REF_QUAL:SS42000_SYN_OR_ACCESS_ERR

%
Parameters:
  %0c - <qualifier> found in a <column reference>;
        may be of format <table name>, <correlation name>, or
        <schema name>.<table name>

Explanation:
  A <qualifier> found in a <column reference> did not identify any of the
  <table reference>s within whose scope the <column reference> appeared.
  
  A <column reference> found in a <target list> or <group by clause> of a
  query may only reference tables appearing in the <from list> (or
  equivalent) at the same scope.

  A <column reference> found outside of a <target list> or <group by
  clause> of a query may reference tables appearing in the <from list>
  (or equivalent) at the same scope or in outer subselects.

  A <column reference> in CHECK constraint found outside of subselects,
  must reference the table on which CHECK constraint is being defined.
  
System Status:
  The current statement is aborted; the program continues.

Recommendation:
  Correct the query and reenter.

Hope this help,
Jean-Pierre