answered my question.
The ODBC and JDBC catalog views are designed to satisfy ODBC and JDBC metadata API requests. For example, SQLCOLUMNS. These views are compatible with views on DB2 LUW Version 8. These views will be modified as ODBC or JDBC enhances or modifies their metadata APIs.

These views exist in schema SYSIBM.

On 10/9/2012 2:40 PM, Gqcy wrote:
what things do we need to query SYSIBM (system catalog)
versus QSYS2?

On 10/9/2012 2:33 PM, Scott Klement wrote:
Hi Matt,

Do you just want to do something like this?

select * from qsys2.systables where table_name='Whatever'

On 10/9/2012 2:20 PM, Matt Olson wrote:
Anyone have any idea how to find files in any library using SQL?

I'm used to having a wealth of information available in system views
in various other database platforms but can't seem to find what works
for the AS400.

I tried "select * from syscat.tables where tabname=tabletofind" but
apparently that doesn't exist in the AS400's flavor of DB2.
Additionally SYSIBM.SYSTABLE doesn't seem to exist either.


This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page