Re: Cannot see indexes on as/400

On 5/10/07, tilmann.brenk@xxxxxxxxxx <tilmann.brenk@xxxxxxxxxx> wrote:
>
> I connect to a AS/400 (V5R3) using the JTopen JDBC driver from IBM
> (jt400.jar driverVersion 7.4)
>
> I can see the tables and get contents, etc.
> But I get an error message when I try to expand the INDEX entries belonging
> to a table:
>
> Error:         [SQL0204] INDEXES der Art *FILE in SYSCAT nicht gefunden.
> [not found]
> SQLState:  42704
> ErrorCode: -204
>
> Is there some configuration missing?

The DB2 plugin creates those Index nodes under the table by querying
the system catalog with the following query:

select INDNAME from SYSCAT.INDEXES
where TABSCHEMA = <schema>
and TABNAME = <table>

>From the DB2 plugin help document:

The DB2 plugin adds DB2-specific functionality to the SQuirreL SQL
Client. Read access is required to the following system views in order
for this additional functionality to work correctly:
SYSCAT.DATATYPES
SYSCAT.INDEXES
SYSCAT.PROCEDURES
SYSCAT.SEQUENCES
SYSCAT.TABLES
SYSCAT.TABLESPACES
SYSCAT.TRIGGERS
SYSCAT.VIEWS

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/