|
Problem IC59968
|
Status: Closed |
SELECT OF NON-EXISTENT COLUMN ON TABLE USING RESERVED WORD FOR C OLUMN NAME RETURNS -9628 INSTEAD OF -217 ERROR |
| product: |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 |
| Problem description: |
A table created with "integer" as a column name can be
queried via methods described in documentation
(table_name.column_name or * in select list), but will return
-9628 when you use table_name.no_such_column to select a
non-existent column from the table. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* IDS 11.50 users using reserved words for column names *
****************************************************************
* PROBLEM DESCRIPTION: *
* A table created with "integer" as a column name will return *
* -9628 when you use table_name.no_such_column to select a *
* *
* non-existent column from the table. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to IDS 11.50.xC5 *
**************************************************************** |
| Local Fix: |
The workaround is to not use reserved words for object names or
to insure that non-existent objects are not included in queries
of tables that use this naming convention and specify table_name
.column_name in the query. |
| Solution |
Problem has been fixed in IDS 11.50.xC5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.02.2009
23.07.2009
23.07.2009 |
| Problem solved at the following versions (IBM BugInfos) |
11.50.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 11.50.xC4.W1
|
 |
| 11.50.xC5
|
|
