ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbmult_5.4.0.1/scalarnodenumber.htm

52 lines
3.3 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="NODENUMBER with DB2 Multisystem" />
<meta name="abstract" content="Through the NODENUMBER function, you can determine the node number where a specific row of the distributed relational database is stored." />
<meta name="description" content="Through the NODENUMBER function, you can determine the node number where a specific row of the distributed relational database is stored." />
<meta name="DC.subject" content="scalar function, SQL, NODENUMBER, NODENUMBER scalar function, for SQL" />
<meta name="keywords" content="scalar function, SQL, NODENUMBER, NODENUMBER scalar function, for SQL" />
<meta name="DC.Relation" scheme="URI" content="RZAF3C4-gen5.htm" />
<meta name="DC.Relation" scheme="URI" content="nodenumex.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="scalarnodenumber" />
<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>NODENUMBER with DB2 Multisystem</title>
</head>
<body id="scalarnodenumber"><a name="scalarnodenumber"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">NODENUMBER with DB2<sup>®</sup> Multisystem</h1>
<div><p>Through the NODENUMBER function, you can determine the node number
where a specific row of the distributed relational database is stored.</p>
<p>The node number is the unique number assigned to each node within a node
group when the node group was created. Knowing the node number allows you
to determine the system name that contains the row. This can be useful in
determining if you want to redistribute certain rows to a specific node.</p>
</div>
<div>
<ul class="ullinks">
<li class="ulchildlink"><strong><a href="nodenumex.htm">Example of NODENUMBER with DB2 Multisystem</a></strong><br />
Here is an example of how to use the NODENUMBER function.</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>