71 lines
5.1 KiB
HTML
71 lines
5.1 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="Connect to a distributed relational database" />
|
||
|
|
<meta name="abstract" content="What makes a distributed relational database application distributed is its ability to connect to a relational database on another server." />
|
||
|
|
<meta name="description" content="What makes a distributed relational database application distributed is its ability to connect to a relational database on another server." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1progdrd.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1cmrwj.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1adduwmg.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1implicit.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1nondefault.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1excon.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1drdastatement.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="rbal1cnct" />
|
||
|
|
<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>Connect to a distributed relational database</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1cnct"><a name="rbal1cnct"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Connect to a distributed relational database</h1>
|
||
|
|
<div><p>What makes a distributed relational database application <em>distributed</em> is
|
||
|
|
its ability to connect to a relational database on another server.</p>
|
||
|
|
<div class="p">There are two types of CONNECT statements with the same syntax but different
|
||
|
|
semantics: <ul><li>CONNECT (Type 1) is used for remote unit of work.</li>
|
||
|
|
<li>CONNECT (Type 2) is used for distributed unit of work.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<p>For embedded SQL applications, the RDBCNNMTH parameter on
|
||
|
|
the CRTSQLxxx commands determines the type of CONNECT. CLI and Java™ applications
|
||
|
|
always use distributed unit of work because of the nature of the language.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1cmrwj.htm">Remote unit of work</a></strong><br />
|
||
|
|
The <em>remote unit of work</em> facility provides for the remote
|
||
|
|
preparation and processing of SQL statements.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1adduwmg.htm">Distributed unit of work</a></strong><br />
|
||
|
|
The application-directed distributed unit of work facility also provides for the remote preparation and execution of SQL statements in the same fashion as remote unit of work.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1implicit.htm">Implicit connection management for the default activation group</a></strong><br />
|
||
|
|
The application requester can implicitly connect to an application server.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1nondefault.htm">Implicit connection management for nondefault activation groups</a></strong><br />
|
||
|
|
The application requester can implicitly connect to an application server.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1excon.htm">Explicit connection management</a></strong><br />
|
||
|
|
The CONNECT statement is used to explicitly connect an application requester (AR) to an identified application server (AS). This SQL statement can be embedded within an application program or you can issue it using Interactive SQL.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1progdrd.htm" title="Programming considerations for a distributed relational database application on an iSeries server fall into two main categories: those that deal with a function that is supported on the local server and those that are a result of having to connect to other servers.">Programming considerations for a distributed relational database application</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="rbal1drdastatement.htm" title="The statements included with the SQL language specifically support a distributed relational database.">Distributed relational database statements</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|