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.
