<div>
<div class="content wysiwyg-content">
I am working on a tool to issue queries to DB2 on an AS/400 (iSeries) system. &nbsp;<a href="http://sourceforge.net/projects/sqlqueryagent" rel="ugc">http://sourceforge.net/projects/sqlqueryagent</a><br />
<br />
Is there a way, using SQL, to:<br />
1. &nbsp;List all the databases on that instance of DB2<br />
2. &nbsp;List all the tables in a DB<br />
3. &nbsp;List all the view in a DB<br />
<br />
Thanks!
</div>
</div>


I am working on a tool to issue queries to DB2 on an AS/400 (iSeries) system.  http://sourceforge.net/projects/sqlqueryagent

Is there a way, using SQL, to:
1.  List all the databases on that instance of DB2
2.  List all the tables in a DB
3.  List all the view in a DB

Thanks!

DB2 on AS/400 (iSeries) -- How do I list databases, tables, views?

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.