Re: [Squirrel-sql-users] Cannot see indexes on as/400

[Robert M. <rob...@gm...>]

On 5/10/07, til...@ka... <til...@ka...> 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