iSeries™ Access for Web provides support for accessing database tables on a system.
A list of tasks that can be performed follows. Any of these tasks can be restricted using the customize function.
A list of database tables on the system can be displayed. The set of tables shown in the list can be customized for individual users. From the tables list, the contents of a table or an individual record can be displayed. Table records can also be inserted or updated.
SQL statements can be run and the results can be viewed in a paged list or returned in one the supported file formats. The layout of the result data can be customized using the file format options. The results of the SQL statement can be sent to the browser, sent to the iSeries integrated file system, placed in a user's personal folder, or mailed as an e-mail attachment. An SQL wizard is provided to help build SQL SELECT statements. SQL requests can be saved for repeated use. Support is also provided for running prompted statements with the use of parameter markers. See Database considerations for more information.
A data file, in one of the supported file formats, can be copied into a relational database table on the system. Options are available to create a new table, append to an existing table, or replace the contents of an existing table. Copy data to table requests can be saved for repeated use.
A list of saved SQL and copy data to table requests can be displayed and managed. Requests can be run and modified. Requests can be shared with other users by creating shortcuts to them. Requests can also be copied, deleted, and renamed.
IBM® Client Access for Windows® or Client Access Express Data Transfer request files can be imported and converted to iSeries Access for Web format. Data Transfer from iSeries server requests are converted to SQL requests. Data Transfer to iSeries server requests are converted to copy data to table requests.
SQL statements contained in IBM Query for iSeries and DB2® UDB for iSeries Query Manager query objects can be imported and converted to iSeries Access for Web SQL request format.
Information about objects on the system can be extracted and the results can be stored in a database table. General object information can be retrieved for any iSeries object type. The object information to extract and store can be customized when the Extract Data is performed. Object specific information can also be retrieved for the following object types: