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

[<til...@ka...>]

The url is:
jdbc:as400://<SystemName>
(It also work with jdbc:as400://<SystemName>/<Library> but it does not=20
make a difference to my problem.)

The class name is:
com.ibm.as400.access.AS400JDBCDriver

The error message suggests that there should be a file object INDEXES in a =

library named SYSCAT.=20
I could not find such an object.

Tilmann Brenk





"Harris, Bernard W" <bh...@we...>=20
10.05.2007 14:46

An
<til...@ka...>
Kopie

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






Hello,
=20
Our company has been using SQuirreL for over a year now connecting to the=20
AS/400 via V5R3 and we have never seen this error.  I am not sure the=20
version of jt400.jar we are using but I am guessing it?s across the board. =

 I personally am using the Client Access version of this and my version of =

Client Access is V5R4 latest SP.  I also just tested the Indexes tab from=20
multiple tables and it showed the key fields without error.  What do you=20
have your URL and class set to?
=20
Bernard Harris
Project Manager
Weather Shield Mfg., Inc.
bh...@we...
=20

From: squ...@li...=20
[mailto:squ...@li...] On Behalf Of=20
til...@ka...
Sent: Thursday, May 10, 2007 1:08 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Cannot see indexes on as/400
=20

I connect to a AS/400 (V5R3) using the JTopen JDBC driver from IBM=20
(jt400.jar driverVersion 7.4)=20

I can see the tables and get contents, etc.=20
But I get an error message when I try to expand the INDEX entries=20
belonging to a table:=20

Error:         [SQL0204] INDEXES der Art *FILE in SYSCAT nicht gefunden.=20
[not found]=20
SQLState:  42704=20
ErrorCode: -204=20

Is there some configuration missing?=20

Thank you for any help,

Tilmann Brenk
=20
Kaimer GmbH & Co. Holding KG
Kommanditgesellschaft mit Sitz in Essen =B7 Amtsgericht Essen =B7 HRA 6843
=20
Kaimer GmbH =B7 Geschaeftsfuehrer: Marianne Kaimer, Friedhelm Kaimer, Bernd=
=20
Kaimer
Amtsgericht Essen =B7 HRB 13343


Kaimer GmbH & Co. Holding KG
Kommanditgesellschaft mit Sitz in Essen =B7 Amtsgericht Essen =B7 HRA 684=
3

Kaimer GmbH =B7 Geschaeftsfuehrer: Marianne Kaimer, Friedhelm Kaimer, Ber=
nd Kaimer
Amtsgericht Essen =B7 HRB 13343
=0D