iSeries™ Access for Web provides support for accessing database tables on an iSeries server.
The list of available portlets follows:
iSeries Database Table displays a list of database table records. An SQL wizard is provided to help filter the list of records displayed. From the list, table records can be inserted, updated, or deleted. Options are provided to customize how the insert and update forms are displayed.
iSeries Dynamic SQL runs SQL statements and displays the results in a paged table or in a supported client file format. This portlet is not restricted to query statements. Any SQL statement supported by the IBM® Toolbox for Java™ JDBC driver can be run.
iSeries SQL Query displays the results of an SQL query in a paged table or in a supported client file format. An SQL wizard is provided to help build the query statement. The wizard can also build prompted queries using parameter markers.
iSeries SQL Requests is used to display and manage a list of saved SQL requests. The list can contain requests for the current WebSphere® Portal user or requests with a specified share name. From the list, requests can be created, updated and deleted. Requests can also be sent to the iSeries SQL Results - Viewer portlet where the statement is run and the SQL results are displayed. See Database considerations for required configuration information.
iSeries SQL Results - Viewer can receive a request from user interaction with the iSeries SQL Requests portlet, run the statement specified in the request, and display the SQL results using the request output settings.
Related concepts
Cooperative portlets