<!--Copyright 1999,2008 Oracle. All rights reserved.--> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1"> <title>Sequence Commands</title> </head> <body> <h2><a name="Database Commands"></a>Sequence Commands</h2> <b>> berkdb sequence [-auto_commit] [-txn txnid] [-create] </b><br> <div style="margin-left: 40px;"> Implements <a href="file:///home/ubell/db.new/docs/seq/seq_open.html">DBENV->sequence</a> function. The above options have the usual meanings.<br> </div> <span style="font-weight: bold;">[-cachesize]</span><br> <div style="margin-left: 40px;">Set the size of the cache in this handle.<br> </div> <span style="font-weight: bold;">[-inc]<br> </span> <div style="margin-left: 40px;">Sequence increments..<br> </div> <span style="font-weight: bold;">[-dec]<br> </span> <div style="margin-left: 40px;">Sequence decrements.<br> </div> <span style="font-weight: bold;">[-init integer]<br> </span> <div style="margin-left: 40px;">Set the initial value for sequence.<br> </div> <span style="font-weight: bold;">[-max integer]</span><br> <div style="margin-left: 40px;">Set the maximum value for the sequence.<br> </div> <span style="font-weight: bold;">[-max integer]<br> </span> <div style="margin-left: 40px;">Set the minimum value for the sequence.<br> </div> <span style="font-weight: bold;">[-wrap]</span><br> <div style="margin-left: 40px;">Wrap around at max or min.<br> </div> <span style="font-weight: bold;"><span style="font-style: italic;">db</span> key<br> </span> <div style="margin-left: 40px;">Database handle and key of sequence.<br> </div> <hr width="100%"><span style="font-style: italic;"><span style="font-weight: bold;">> seq </span></span><span style="font-weight: bold;">get [-txn <span style="font-style: italic;">txn</span>] [-auto_commit] [-nosync] delta<br> </span> <div style="margin-left: 40px;">Get the nexted sequence value and increment the sequence by <span style="font-weight: bold;">delta</span>.<br> </div> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq </span>close</span><br> <div style="margin-left: 40px;">Close the sequence<br> </div> <br> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq</span> remove [-auto_commit] [-nosync] [-txn] <br> </span> <div style="margin-left: 40px;">Remove the sequence.<br> </div> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq </span>get_cachesize<br> </span> <div style="margin-left: 40px;">Return the size of the cache.<br> </div> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq </span>get_db<br> </span> <div style="margin-left: 40px;">Return the underlying db handle.<br> </div> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq </span>get_flags</span><br> <div style="margin-left: 40px;">Return the flags set on create.<br> </div> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq</span> get_range<br> </span> <div style="margin-left: 40px;">Return the min and max set at create.<br> </div> <hr width="100%"><span style="font-weight: bold;">> <span style="font-style: italic;">seq </span>stat<br> </span> <div style="margin-left: 40px;">Implements the <a href="../../docs/seq/seq_stat.html">SEQUENCE->stat</a> function.<br> </div> <hr width="100%"> </body> </html>