Edit File - File Manager

Edit File: db_cursor.html

<html>
<head>
<title>Berkeley DB: DB-&gt;cursor</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>
DB-&gt;cursor
</td>
<td align=right>
<a href="../../db4-devel-4.7.25/api_c/api_core.html"><img src="../../db4-devel-4.7.25/images/api.gif" alt="API"></a>
<a href="../../db4-devel-4.7.25/ref/toc.html"><img src="../../db4-devel-4.7.25/images/ref.gif" alt="Ref"></a></td>
</tr></table>
<hr size=1 noshade>
<tt>
<pre>
#include &lt;db.h&gt;

int
DB-&gt;cursor(DB *db,
 DB_TXN *txnid, DBC **cursorp, u_int32_t flags);
</pre>
<hr size=1 noshade>
Description: DB-&gt;cursor
The DB-&gt;cursor method returns a created database cursor.
Cursors may span threads, but only serially, that is, the application
must serialize access to the cursor handle.
The DB-&gt;cursor method
returns a non-zero error value on failure
and 0 on success.

Parameters 
 cursorp<ul compact><li>The cursorp parameter references memory into which
a pointer to the allocated cursor is copied.</ul> 
 flags<ul compact><li>The flags parameter must be set to 0 or by bitwise inclusively OR'ing together one
or more of the following values:
 
<a name="DB_READ_COMMITTED">DB_READ_COMMITTED</a><ul compact><li>Configure a transactional cursor to have degree 2 isolation. This ensures
the stability of the current data item read by this cursor but permits data
read by this cursor to be modified or deleted prior to the commit of the
transaction for this cursor.</ul>
<a name="DB_READ_UNCOMMITTED">DB_READ_UNCOMMITTED</a><ul compact><li>Configure a transactional cursor to have degree 1 isolation. Read
operations performed by the cursor may return modified but not yet
committed data. Silently ignored if the <a href="../../db4-devel-4.7.25/api_c/db_open.html#DB_READ_UNCOMMITTED">DB_READ_UNCOMMITTED</a>
flag was not specified when the underlying database was opened.</ul>
<a name="DB_WRITECURSOR">DB_WRITECURSOR</a><ul compact><li>Specify that the cursor will be used to update the database. The
underlying database environment must have been opened using the
<a href="../../db4-devel-4.7.25/api_c/env_open.html#DB_INIT_CDB">DB_INIT_CDB</a> flag.</ul>
<a name="DB_TXN_SNAPSHOT">DB_TXN_SNAPSHOT</a><ul compact><li>Configure a transactional cursor to operate with read-only
<a href="../../db4-devel-4.7.25/ref/transapp/read.html">snapshot isolation</a>. For databases
with the <a href="../../db4-devel-4.7.25/api_c/db_open.html#DB_MULTIVERSION">DB_MULTIVERSION</a> flag set, data values will be read as
they are when the cursor is opened, without taking read locks. This
flag implicitly begins a transaction that is committed when the cursor
is closed. Silently ignored if <a href="../../db4-devel-4.7.25/api_c/db_open.html#DB_MULTIVERSION">DB_MULTIVERSION</a> not set on the
underlying database or if a transaction is supplied in the txnid
parameter.</ul>
 </ul>
 txnid<ul compact><li>Cursor operations are not automatically transaction-protected, even if
the <a href="../../db4-devel-4.7.25/api_c/env_set_flags.html#DB_AUTO_COMMIT">DB_AUTO_COMMIT</a> flag is specified to the
<a href="../../db4-devel-4.7.25/api_c/env_set_flags.html">DB_ENV-&gt;set_flags</a> or <a href="../../db4-devel-4.7.25/api_c/db_open.html">DB-&gt;open</a> methods. If cursor operations are
to be transaction-protected, the txnid parameter must be a
transaction handle returned from <a href="../../db4-devel-4.7.25/api_c/txn_begin.html">DB_ENV-&gt;txn_begin</a>; otherwise, NULL. To
transaction-protect cursor operations, cursors must be opened and closed
within the context of a transaction, and the txnid parameter
specifies the transaction context in which the cursor may be used.</ul>
 
 Errors
The DB-&gt;cursor method
may fail and return one of the following non-zero errors:
 
DB_REP_HANDLE_DEAD<ul compact><li>The database handle has been invalidated because a replication election
unrolled a committed transaction.</ul>
 
 
DB_REP_LOCKOUT<ul compact><li>The operation was blocked by client/master synchronization.</ul>
 
 
EINVAL<ul compact><li>An
invalid flag value or parameter was specified.</ul>
 
<hr size=1 noshade>
 Class
<a href="../../db4-devel-4.7.25/api_c/dbc_class.html">DBC</a>
 See Also
<a href="../../db4-devel-4.7.25/api_c/dbc_list.html">Database Cursors and Related Methods</a>
</tt>
<table width="100%"><tr><td> </td><td align=right>
<a href="../../db4-devel-4.7.25/api_c/api_core.html"><img src="../../db4-devel-4.7.25/images/api.gif" alt="API"></a><a href="../../db4-devel-4.7.25/ref/toc.html"><img src="../../db4-devel-4.7.25/images/ref.gif" alt="Ref"></a>
</td></tr></table>
Copyright (c) 1996,2008 Oracle. All rights reserved.
</body>
</html>

Back to File Manager