SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-12-10 11:34:30

matto
Member

Unable to get list of tables on IBM i Access DB2 driver

Support,

I am able to get connected via ODBC driver and can retrieve list of all tables.

However I am now trying to use the IBM i Client Access Drivers, and I am able to get connected.

However the table list is empty.  It is only able to see System Objects>>Tables (where it thoses the QSYS2.* and SYSIBM.* tables).

I have went to Connection: Schema / Database Filter and added the database in several different variations (Master database name, library name, [master database name].[Library name]) and did the Connection>>Refresh Object List, but still tables list has no items.

Using SqlDBx 4.5 Professional

Offline

#2 2014-12-10 11:44:11

sqldbxhelp
Administrator

Re: Unable to get list of tables on IBM i Access DB2 driver

Did you select DBMS Type "IBM DB2 iSeries" on login screen?
After connecting do you see list of schemas in combo box on toolbar?
What happens when you select different schemas from combo box list?

Offline

#3 2014-12-10 11:46:37

matto
Member

Re: Unable to get list of tables on IBM i Access DB2 driver

Sorry, I figured it out.

In the ODBC route I normally seen LIBARRY.TABLENAME prefixes for all the librarys in my schema list.

In this version I see how things work, you select the database from the drop down in the query window, and only then does it populate the table list.

Which is fine for me.

Offline

Board footer

Powered by FluxBB