Re: [Squirrel-sql-users] All_tables on DB2/400 (WAS:no subject)

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

SQuirreL uses a Java API (DatabaseMetaData.getTables) to access this
information using whatever mechanism implements getting this
information in the JDBC driver.  The exact data dictionary to query
changes between the platforms that DB2 runs on (UDB vs. OS/400).
Nevertheless, we do have some queries in the DB2 plugin for table
indexes (qsys2.sysindexes) and table triggers (qsys2.systriggers).
Perhaps there is a "qsys2.systables" ?

Rob

On Tue, Mar 3, 2009 at 8:27 AM, Erwan DUROSELLE
<erw...@ho...> wrote:
> sorry for no subject
> Erwan
>
> ________________________________
> From: erw...@ho...
> To: squ...@li...
> Date: Tue, 3 Mar 2009 11:31:10 +0000
> Subject: [Squirrel-sql-users] (no subject)
>
> Hi,
>
> I am trying to get the list of all tables on DB2/400 and on Oracle to
> compare 2 schemas.
>
> on Oracle, I can get this using select * from all_tables.
> On DB2, I don't know, but Squirrel does.
>
> How can I show what query SQuirreL executes to get the list of all
> tables/objects of a schema?
>
>
> Erwan
> ________________________________
> Vous voulez savoir ce que vous pouvez faire avec le nouveau Windows Live ?
> Lancez-vous !
> ________________________________
> Vous voulez savoir ce que vous pouvez faire avec le nouveau Windows Live ?
> Lancez-vous !
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>