44 lines
3.1 KiB
HTML
44 lines
3.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="Relative record numbering function with DB2 Multisystem" />
|
|
<meta name="abstract" content="The relative record numbering (RRN) function returns the relative record number of the row stored on a node in a distributed file." />
|
|
<meta name="description" content="The relative record numbering (RRN) function returns the relative record number of the row stored on a node in a distributed file." />
|
|
<meta name="DC.subject" content="function, SQL, relative record numbering (RRN), relative record numbering (RRN) function, RRN (relative record numbering) function" />
|
|
<meta name="keywords" content="function, SQL, relative record numbering (RRN), relative record numbering (RRN) function, RRN (relative record numbering) function" />
|
|
<meta name="DC.Relation" scheme="URI" content="spreg.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="rrn" />
|
|
<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>Relative record numbering function with DB2 Multisystem</title>
|
|
</head>
|
|
<body id="rrn"><a name="rrn"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Relative record numbering function with DB2<sup>®</sup> Multisystem</h1>
|
|
<div><p>The relative record numbering (RRN) function returns
|
|
the relative record number of the row stored on a node in a distributed file.</p>
|
|
<p>RRN is not unique for a distributed file. A unique record
|
|
in the file is specified if you combine RRN with either NODENAME or NODENUMBER.</p>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="spreg.htm" title="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.">Special registers with DB2 Multisystem</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |