MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: Find files in any library



fixed

http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcatalog.htm

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.

Thanks!








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

This mailing list archive is Copyright 1997-2014 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