Antwort: RE: Cannot see indexes on as/400

The url is:
jdbc:as400://<SystemName>
(It also work with jdbc:as400://<SystemName>/<Library>
but it does not 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. 
I could not find such an object.

Tilmann Brenk

"Harris, Bernard W" <bharris@xxxxxxxxxxxxxxxxx>

10.05.2007 14:46

An	<tilmann.brenk@xxxxxxxxxx>
Kopie
Thema	RE: [Squirrel-sql-users] Cannot see indexes on as/400

Hello,
 
Our company has been using
SQuirreL for over a year now connecting to the AS/400 via V5R3 and we have
never seen this error.  I am not sure the 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 multiple
tables and it showed the key fields without error.  What do you have
your URL and class set to?
 
Bernard Harris
Project Manager
Weather Shield Mfg., Inc.
bharris@xxxxxxxxxxxxxxxxx

---

From: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf
Of tilmann.brenk@xxxxxxxxxx
Sent: Thursday, May 10, 2007 1:08 AM
To: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: [Squirrel-sql-users] Cannot see indexes on as/400
 

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?

Thank you for any help,

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

Kaimer GmbH & Co. Holding KG
Kommanditgesellschaft mit Sitz in Essen � Amtsgericht Essen � HRA 6843

Kaimer GmbH � Geschaeftsfuehrer: Marianne Kaimer, Friedhelm Kaimer, Bernd Kaimer
Amtsgericht Essen � HRB 13343

-------------------------------------------------------------------------

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/_______________________________________________

Squirrel-sql-users mailing list

Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx

https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users