<!--$Id: db_join.so,v 11.22 2002/08/18 21:17:26 bostic Exp $--> <!--$Id: m4.tcl,v 11.28 2004/12/16 19:13:05 bostic Exp $--> <!--Copyright (c) 1997,2007 Oracle. All rights reserved.--> <!--See the file LICENSE for redistribution information.--> <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,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,Java,C,C++"> </head> <body bgcolor=white> <table width="100%"><tr valign=top> <td> <h3><i>db</i> <b>join</b></h3> </td> <td align=right> <a href="../../db46-devel-4.6.21/api_tcl/api_tcl.html"><img src="../../db46-devel-4.6.21/images/api.gif" alt="API"></a> <a href="../../db46-devel-4.6.21/ref/toc.html"><img src="../../db46-devel-4.6.21/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> <h3>Description(db join)</h3> <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 (for example, db0.c0 and db0.c1). It is through this Tcl command that the script accesses the cursor methods.</p> <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> <p>See <a href="../../db46-devel-4.6.21/ref/am/join.html">Equality join</a> for more information on the underlying requirements for joining.</p> <p>In a transaction-protected environment, all the cursors listed must have been created within the same transaction.</p> <p>In the case of error, a Tcl error is thrown.</p> </tt> <table width="100%"><tr><td><br></td><td align=right> <a href="../../db46-devel-4.6.21/api_tcl/api_tcl.html"><img src="../../db46-devel-4.6.21/images/api.gif" alt="API"></a><a href="../../db46-devel-4.6.21/ref/toc.html"><img src="../../db46-devel-4.6.21/images/ref.gif" alt="Ref"></a> </td></tr></table> <p><font size=1>Copyright (c) 1996,2007 Oracle. All rights reserved.</font> </body> </html>