ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzaii_5.4.0.1/rzaiimst18.htm

79 lines
4.9 KiB
HTML
Raw Permalink Normal View History

2024-04-02 14:02:31 +00:00
<?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 server" />
<meta name="abstract" content="For Data Transfer, ODBC, iSeries Navigator database, and iSeries Access for Windows providers (OLE DB and the .NET Data provider)." />
<meta name="description" content="For Data Transfer, ODBC, iSeries Navigator database, and iSeries Access for Windows providers (OLE DB and the .NET Data provider)." />
<meta name="DC.Relation" scheme="URI" content="rzaiicahstsvr.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiimst18a.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiimst38.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiimst39.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiimst40.htm" />
<meta name="DC.Relation" scheme="URI" content="../ddp/rbal1kickoff.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rzaiimst18" />
<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 server</title>
</head>
<body id="rzaiimst18"><a name="rzaiimst18"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Database server</h1>
<div><p>For Data Transfer, ODBC, iSeries™ Navigator database, and iSeries Access
for Windows<sup>®</sup> providers
(OLE DB and the .NET Data provider).</p>
<p>The database server allows clients access to the functions included with <strong>DB2<sup>®</sup> UDB
for iSeries </strong>.
This server provides:</p>
<ul><li>Support for remote SQL access</li>
<li>Access to data through ODBC, ADO, OLE DB, and .NET Data Provider interfaces</li>
<li>Database functions (such as creating and deleting files and adding and
removing file members)</li>
<li>Retrieval functions for obtaining information about database files that
exist on the system (such as SQL catalog functions)</li>
</ul>
<p>Additionally, you can use Distributed Relational
Database Architecture™ (DRDA<sup>®</sup>) with the database server and with SQL packages. DRDA is
not supported by OLE DB or the .NET Data Provider. </p>
<p>Choose from the following topics for more information on working with DRDA.
Also, see the Distributed database programming topic collection for additional
information about DRDA. </p>
</div>
<div>
<ul class="ullinks">
<li class="ulchildlink"><strong><a href="rzaiimst18a.htm">Database server programs</a></strong><br />
See a list of database server programs with descriptions and associated libraries.</li>
<li class="ulchildlink"><strong><a href="rzaiimst38.htm">SQL packages</a></strong><br />
SQL packages bind SQL statements in an application program to a relational database. They are used to enhance the performance of applications that use dynamic SQL support by allowing the application to reuse information about the SQL requests.</li>
<li class="ulchildlink"><strong><a href="rzaiimst39.htm">Statement naming conventions</a></strong><br />
Identify enforced naming conventions.</li>
<li class="ulchildlink"><strong><a href="rzaiimst40.htm">Rules and restrictions when using DRDA</a></strong><br />
Distributed
Relational Database Architecture™ (DRDA) is an architecture that allows access
to other databases that support DRDA. For more information about DRDA, see Distributed
database programming.</li>
</ul>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaiicahstsvr.htm" title="Describes many of the host servers that are common in the iSeries Access for Windows client and the related objects. You can view the servers by type or by their function in iSeries Access for Windows.">Identify i5/OS host servers and associated programs.</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="../ddp/rbal1kickoff.htm">Distributed database programming</a></div>
</div>
</div>
</body>
</html>