<!--$Id: db_join.so,v 11.16 2000/12/04 18:05:39 bostic Exp $--> <!--$Id: m4.tcl,v 11.17 2000/04/24 17:31:11 sue Exp $--> <!--Copyright 1997, 1998, 1999, 2000 by Sleepycat Software, Inc.--> <!--All rights reserved.--> <html> <head> <title>Berkeley DB: db join</title> <meta name="description" content="Berkeley DB: An embedded database programmatic toolkit."> <meta name="keywords" content="embedded,database,programmatic,toolkit,b+tree,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,java,C,C++"> </head> <body bgcolor=white> <a name="2"><!--meow--></a> <table><tr valign=top> <td> <h1><i>db</i> <b>join</b></h1> </td> <td width="1%"> <a href="../api_tcl/tcl_index.html"><img src="../images/api.gif" alt="API"></a><a href="../ref/toc.html"><img src="../images/ref.gif" alt="Ref"></a> </td></tr></table> <hr size=1 noshade> <tt> <h3><pre>db join <i>db.cX</i> <i>db.cY</i> <i>db.cZ</i> ... </pre></h3> <h1>Description</h1> <p>The <i>db</i> <b>join</b> command joins the specified cursors and returns a cursor handle that can be used to iterate through the joined {key data} pairs. The returned cursor handle is bound to a Tcl command of the form <b>dbN.cX</b>, where X is an integer starting at 0 (e.g., db0.c0 and db0.c1). It is through this Tcl command that the script accesses the cursor methods. <p>The returned join cursor has limited cursor functionality and only the <i>dbc</i> <b>get</b> and <i>dbc</i> <b>close</b> commands will succeed. <p>See <a href="../ref/am/join.html">Logical join</a> for more information on the underlying requirements for joining. <p>In a transaction protected environment, all of the cursors listed must have been created within the same transaction. <p>In the case of error, a Tcl error is thrown. </tt> <table><tr><td><br></td><td width="1%"> <a href="../api_tcl/tcl_index.html"><img src="../images/api.gif" alt="API"></a><a href="../ref/toc.html"><img src="../images/ref.gif" alt="Ref"></a> </td></tr></table> <p><font size=1><a href="http://www.sleepycat.com">Copyright Sleepycat Software</a></font> </body> </html>