1<?xml version="1.0" encoding="UTF-8" standalone="no"?> 2<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 3<html xmlns="http://www.w3.org/1999/xhtml"> 4 <head> 5 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> 6 <title>Chapter 11. The DB_SEQUENCE Handle</title> 7 <link rel="stylesheet" href="apiReference.css" type="text/css" /> 8 <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> 9 <link rel="start" href="index.html" title="Berkeley DB C API Reference" /> 10 <link rel="up" href="index.html" title="Berkeley DB C API Reference" /> 11 <link rel="prev" href="repmgrstat_print.html" title="DB_ENV->repmgr_stat_print()" /> 12 <link rel="next" href="seqcreate.html" title="db_sequence_create" /> 13 </head> 14 <body> 15 <div class="navheader"> 16 <table width="100%" summary="Navigation header"> 17 <tr> 18 <th colspan="3" align="center">Chapter 11. 19 The DB_SEQUENCE Handle 20 </th> 21 </tr> 22 <tr> 23 <td width="20%" align="left"><a accesskey="p" href="repmgrstat_print.html">Prev</a> </td> 24 <th width="60%" align="center"> </th> 25 <td width="20%" align="right"> <a accesskey="n" href="seqcreate.html">Next</a></td> 26 </tr> 27 </table> 28 <hr /> 29 </div> 30 <div class="chapter" lang="en" xml:lang="en"> 31 <div class="titlepage"> 32 <div> 33 <div> 34 <h2 class="title"><a id="seq"></a>Chapter 11. 35 The DB_SEQUENCE Handle 36 </h2> 37 </div> 38 </div> 39 </div> 40 <p> 41 Sequences provide an arbitrary number of persistent objects that return an 42 increasing or decreasing sequence of integers. Opening a sequence handle associates 43 it with a record in a database. The handle can maintain a cache of values from the 44 database so that a database update is not needed as the application allocates a 45 value. 46 </p> 47 <p> 48 A sequence is stored as a record pair in a database. The database may be of any 49 type, but must not have been configured to support duplicate data items. The sequence 50 is referenced by the key used when the sequence is created, therefore the key must 51 be compatible with the underlying access method. If the database stores fixed-length 52 records, the record size must be at least 64 bytes long. 53 </p> 54 <p> 55 You create a sequence using the 56 <a class="xref" href="seqcreate.html" title="db_sequence_create">db_sequence_create</a> method. 57 </p> 58 <p> 59 For more information on sequences, see the 60 <em class="citetitle">Berkeley DB Programmer's Reference Guide</em> guide. 61 </p> 62 <div class="sect1" lang="en" xml:lang="en"> 63 <div class="titlepage"> 64 <div> 65 <div> 66 <h2 class="title" style="clear: both"><a id="seqlist"></a>Sequences and Related Methods</h2> 67 </div> 68 </div> 69 </div> 70 <div class="navtable"> 71 <table border="1" width="80%"> 72 <thead> 73 <tr> 74 <th>Sequences and Related Methods</th> 75 <th>Description</th> 76 </tr> 77 </thead> 78 <tbody> 79 <tr> 80 <td> 81 <a class="xref" href="seqcreate.html" title="db_sequence_create">db_sequence_create</a> 82 </td> 83 <td>Create a sequence handle</td> 84 </tr> 85 <tr> 86 <td> 87 <a class="xref" href="seqclose.html" title="DB_SEQUENCE->close()">DB_SEQUENCE->close()</a> 88 </td> 89 <td>Close a sequence</td> 90 </tr> 91 <tr> 92 <td> 93 <a class="xref" href="seqget.html" title="DB_SEQUENCE->get()">DB_SEQUENCE->get()</a> 94 </td> 95 <td>Get the next sequence element(s)</td> 96 </tr> 97 <tr> 98 <td> 99 <a class="xref" href="seqget_dbp.html" title="DB_SEQUENCE->get_dbp()">DB_SEQUENCE->get_dbp()</a> 100 </td> 101 <td>Return a handle for the underlying sequence database</td> 102 </tr> 103 <tr> 104 <td> 105 <a class="xref" href="seqget_key.html" title="DB_SEQUENCE->get_key()">DB_SEQUENCE->get_key()</a> 106 </td> 107 <td>Return the key for a sequence</td> 108 </tr> 109 <tr> 110 <td> 111 <a class="xref" href="seqinitial_value.html" title="DB_SEQUENCE->initial_value()">DB_SEQUENCE->initial_value()</a> 112 </td> 113 <td>Set the initial value of a sequence</td> 114 </tr> 115 <tr> 116 <td> 117 <a class="xref" href="seqopen.html" title="DB_SEQUENCE->open()">DB_SEQUENCE->open()</a> 118 </td> 119 <td>Open a sequence</td> 120 </tr> 121 <tr> 122 <td> 123 <a class="xref" href="seqremove.html" title="DB_SEQUENCE->remove()">DB_SEQUENCE->remove()</a> 124 </td> 125 <td>Remove a sequence</td> 126 </tr> 127 <tr> 128 <td> 129 <a class="xref" href="seqstat.html" title="DB_SEQUENCE->stat()">DB_SEQUENCE->stat()</a> 130 </td> 131 <td>Return sequence statistics</td> 132 </tr> 133 <tr> 134 <td> 135 <a class="xref" href="seqstat_print.html" title="DB_SEQUENCE->stat_print()">DB_SEQUENCE->stat_print()</a> 136 </td> 137 <td>Print sequence statistics</td> 138 </tr> 139 <tr> 140 <td colspan="2"> 141 <span class="bold"> 142 <strong>Sequences Configuration</strong> 143 </span> 144 </td> 145 </tr> 146 <tr> 147 <td><a class="xref" href="seqset_cachesize.html" title="DB_SEQUENCE->set_cachesize()">DB_SEQUENCE->set_cachesize()</a>, <a class="xref" href="seqget_cachesize.html" title="DB_SEQUENCE->get_cachesize()">DB_SEQUENCE->get_cachesize()</a></td> 148 <td>Set/get the cache size of a sequence</td> 149 </tr> 150 <tr> 151 <td><a class="xref" href="seqset_flags.html" title="DB_SEQUENCE->set_flags()">DB_SEQUENCE->set_flags()</a>, <a class="xref" href="seqget_flags.html" title="DB_SEQUENCE->get_flags()">DB_SEQUENCE->get_flags()</a></td> 152 <td>Set/get the flags for a sequence</td> 153 </tr> 154 <tr> 155 <td><a class="xref" href="seqset_range.html" title="DB_SEQUENCE->set_range()">DB_SEQUENCE->set_range()</a>, <a class="xref" href="seqget_range.html" title="DB_SEQUENCE->get_range()">DB_SEQUENCE->get_range()</a></td> 156 <td>Set/get the range for a sequence</td> 157 </tr> 158 </tbody> 159 </table> 160 </div> 161 </div> 162 </div> 163 <div class="navfooter"> 164 <hr /> 165 <table width="100%" summary="Navigation footer"> 166 <tr> 167 <td width="40%" align="left"><a accesskey="p" href="repmgrstat_print.html">Prev</a> </td> 168 <td width="20%" align="center"> </td> 169 <td width="40%" align="right"> <a accesskey="n" href="seqcreate.html">Next</a></td> 170 </tr> 171 <tr> 172 <td width="40%" align="left" valign="top">DB_ENV->repmgr_stat_print() </td> 173 <td width="20%" align="center"> 174 <a accesskey="h" href="index.html">Home</a> 175 </td> 176 <td width="40%" align="right" valign="top"> db_sequence_create</td> 177 </tr> 178 </table> 179 </div> 180 </body> 181</html> 182