Filter Indexes, getting error: ERROR [42702] [IBM][DB2/AIX64] SQL0203N A reference to column (4248127)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Filter Indexes, getting error: ERROR [42702] [IBM][DB2/AIX64] SQL0203N A reference to column
Description

Using the additional fileds in the Filter Indexes window, getting the error: ERROR [42702] [IBM][DB2/AIX64] SQL0203N A reference to column "TABSCHEMA" is ambiguous. This is only happening when connection to a db2 db on an AIX server.
Resolution

WORKAROUND
Please follow the steps below for the current workaround:
1. In the Filter enter your properties you want to filter, then go to the SQL tab.
2. Check "Enable Custom SQL" and add the “i.” correlation name to TABSCHEMA. So it will look like Lower (i.TABSCHEMA) LIKE ....
3. Hit OK and now it should work.
STATUS
Waiting for fix in a future release of (Toad for DB2 LUW)
Defect ID

TDB-1381

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title