61 lines
4.0 KiB
HTML
61 lines
4.0 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="Special registers with DB2 Multisystem" />
|
|
<meta name="abstract" content="For DB2 Multisystem, all instances of special registers are resolved on the coordinator node before sending the query to the remote nodes. (A coordinator node is the system on which the query was initiated.) This way, all nodes run the query with consistent special register values." />
|
|
<meta name="description" content="For DB2 Multisystem, all instances of special registers are resolved on the coordinator node before sending the query to the remote nodes. (A coordinator node is the system on which the query was initiated.) This way, all nodes run the query with consistent special register values." />
|
|
<meta name="DC.subject" content="function, SQL, special registers, special register function, for SQL, coordinator node, definition, coordinator node" />
|
|
<meta name="keywords" content="function, SQL, special registers, special register function, for SQL, coordinator node, definition, coordinator node" />
|
|
<meta name="DC.Relation" scheme="URI" content="RZAF3C4-gen5.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rrn.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="spreg" />
|
|
<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>Special registers with DB2 Multisystem</title>
|
|
</head>
|
|
<body id="spreg"><a name="spreg"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Special registers with DB2 Multisystem</h1>
|
|
<div><p>For DB2<sup>®</sup> Multisystem,
|
|
all instances of special registers are resolved on the coordinator node before
|
|
sending the query to the remote nodes. (A <em>coordinator node</em> is
|
|
the system on which the query was initiated.) This way, all nodes run the
|
|
query with consistent special register values.</p>
|
|
<p>The following rules are about special registers:</p>
|
|
<ul><li>CURRENT SERVER always returns the relational database name of the coordinator
|
|
node.</li>
|
|
<li>The USER special register returns the user profile that is running the
|
|
job on the coordinator node.</li>
|
|
<li>CURRENT DATE, CURRENT TIME, and CURRENT TIMESTAMP are from the time-of-day
|
|
clock at the coordinator node.</li>
|
|
<li>CURRENT TIMEZONE is the value of the system value QUTCOFFSET at the coordinator
|
|
node.</li>
|
|
</ul>
|
|
</div>
|
|
<div>
|
|
<ul class="ullinks">
|
|
<li class="ulchildlink"><strong><a href="rrn.htm">Relative record numbering function with DB2 Multisystem</a></strong><br />
|
|
The relative record numbering (RRN) function returns the relative record number of the row stored on a node in a distributed file.</li>
|
|
</ul>
|
|
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="RZAF3C4-gen5.htm" title="For DB2 Multisystem, scalar functions are available when you work with distributed files.">Scalar functions available with DB2 Multisystem</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |