88 lines
4.9 KiB
HTML
88 lines
4.9 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="concept" />
|
||
|
|
<meta name="DC.Title" content="Database" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="pusagenotes.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzammdbportconsider.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzammdbportrestr.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzammportletcooperative.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzammportletcooperative.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2003, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2003, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rzammdatabaseportlets" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Database</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzammdatabaseportlets"><a name="rzammdatabaseportlets"><!-- --></a>
|
||
|
|
<img src="./delta.gif" alt="Start of change" /><!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Database</h1>
|
||
|
|
<div><p>iSeries™ Access
|
||
|
|
for Web provides support for accessing database tables on an iSeries server.</p>
|
||
|
|
<div class="p">The list of available portlets is shown below:<dl><dt class="dlterm">iSeries Database
|
||
|
|
Table</dt>
|
||
|
|
<dd>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.</dd>
|
||
|
|
<dt class="dlterm">iSeries Dynamic
|
||
|
|
SQL</dt>
|
||
|
|
<dd>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<sup>®</sup> Toolbox for Java™ JDBC driver can be run.</dd>
|
||
|
|
<dt class="dlterm">iSeries SQL
|
||
|
|
Query</dt>
|
||
|
|
<dd>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.</dd>
|
||
|
|
<dt class="dlterm">iSeries SQL
|
||
|
|
Requests</dt>
|
||
|
|
<dd> iSeries SQL
|
||
|
|
Requests is used to display and manage a list of saved SQL requests. The list
|
||
|
|
can contain requests for the current WebSphere<sup>®</sup> 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.</dd>
|
||
|
|
<dt class="dlterm">iSeries SQL
|
||
|
|
Results - Viewer</dt>
|
||
|
|
<dd>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.</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rzammdbportconsider.htm">Database considerations</a></strong><br />
|
||
|
|
Learn about considerations associated with using iSeries Access for Web database functions in a portal environment.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzammdbportrestr.htm">Database restrictions</a></strong><br />
|
||
|
|
Learn about restrictions associated with using iSeries Access for Web database functions in a portal environment.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="pusagenotes.htm" title="Learn about the functions provided by the iSeries Access for Web portlets, along with the considerations and restrictions associated with them.">iSeries Access for Web functions</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
||
|
|
<div><a href="rzammportletcooperative.htm" title="Learn about sharing information between portlets.">Cooperative portlets</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<img src="./deltaend.gif" alt="End of change" /></body>
|
||
|
|
</html>
|