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.
what things do we need to query SYSIBM (system catalog)
On 10/9/2012 2:33 PM, Scott Klement wrote:
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 mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact