Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQLCODE 206 CREATOR
68 views
Skip to first unread message
Gregor Kovač
May 21, 2009, 10:37:57 AM5/21/09
to
Hi!
I'm using DB2 Express-C 9.1.2.
SQL "SELECT * FROM SYSCAT.INDEXES" throws as error:
SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: CREATOR
What does it mean?
Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| Gregor Kovac | Gregor...@mikropis.si |
| | http://kovica.blogspot.com |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Serge Rielau
May 22, 2009, 8:49:54 AM5/22/09
to
Gregor Kovac( wrote:
> Hi!
>
> I'm using DB2 Express-C 9.1.2.
> SQL "SELECT * FROM SYSCAT.INDEXES" throws as error:
> SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: CREATOR
>
> What does it mean?
Huh??> Hi!
>
> I'm using DB2 Express-C 9.1.2.
> SQL "SELECT * FROM SYSCAT.INDEXES" throws as error:
> SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: CREATOR
>
> What does it mean?
Get the SYSCAT.VIEWS.TEXT output for that view and do a describe on
the underlying tables.
CREATOR is a column referenced in SYSCAT.INDEXES.
Now, why DB2 wouldn't find that column is beyond me.
Did you apply a fixpack? But even if I don't think we changed the schema....
Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
0 new messages