1<!--Copyright 1999,2008 Oracle. All rights reserved.--> 2<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 3<html> 4<head> 5 <meta http-equiv="content-type" 6 content="text/html; charset=ISO-8859-1"> 7 <title>Sequence Commands</title> 8</head> 9<body> 10<h2><a name="Database Commands"></a>Sequence Commands</h2> 11<b>> berkdb sequence [-auto_commit] [-txn txnid] [-create] </b><br> 12<div style="margin-left: 40px;"> Implements <a 13 href="file:///home/ubell/db.new/docs/seq/seq_open.html">DBENV->sequence</a> 14function. The above options have the usual meanings.<br> 15</div> 16<span style="font-weight: bold;">[-cachesize]</span><br> 17<div style="margin-left: 40px;">Set the size of the cache in this 18handle.<br> 19</div> 20<span style="font-weight: bold;">[-inc]<br> 21</span> 22<div style="margin-left: 40px;">Sequence increments..<br> 23</div> 24<span style="font-weight: bold;">[-dec]<br> 25</span> 26<div style="margin-left: 40px;">Sequence decrements.<br> 27</div> 28<span style="font-weight: bold;">[-init integer]<br> 29</span> 30<div style="margin-left: 40px;">Set the initial value for sequence.<br> 31</div> 32<span style="font-weight: bold;">[-max integer]</span><br> 33<div style="margin-left: 40px;">Set the maximum value for the sequence.<br> 34</div> 35<span style="font-weight: bold;">[-max integer]<br> 36</span> 37<div style="margin-left: 40px;">Set the minimum value for the sequence.<br> 38</div> 39<span style="font-weight: bold;">[-wrap]</span><br> 40<div style="margin-left: 40px;">Wrap around at max or min.<br> 41</div> 42<span style="font-weight: bold;"><span style="font-style: italic;">db</span> 43key<br> 44</span> 45<div style="margin-left: 40px;">Database handle and key of sequence.<br> 46</div> 47<hr width="100%"><span style="font-style: italic;"><span 48 style="font-weight: bold;">> seq </span></span><span 49 style="font-weight: bold;">get [-txn <span style="font-style: italic;">txn</span>] 50[-auto_commit] [-nosync] delta<br> 51</span> 52<div style="margin-left: 40px;">Get the nexted sequence value and 53increment the sequence by <span style="font-weight: bold;">delta</span>.<br> 54</div> 55<hr width="100%"><span style="font-weight: bold;">> <span 56 style="font-style: italic;">seq </span>close</span><br> 57<div style="margin-left: 40px;">Close the sequence<br> 58</div> 59<br> 60<hr width="100%"><span style="font-weight: bold;">> <span 61 style="font-style: italic;">seq</span> remove [-auto_commit] [-nosync] 62[-txn] <br> 63</span> 64<div style="margin-left: 40px;">Remove the sequence.<br> 65</div> 66<hr width="100%"><span style="font-weight: bold;">> <span 67 style="font-style: italic;">seq </span>get_cachesize<br> 68</span> 69<div style="margin-left: 40px;">Return the size of the cache.<br> 70</div> 71<hr width="100%"><span style="font-weight: bold;">> <span 72 style="font-style: italic;">seq </span>get_db<br> 73</span> 74<div style="margin-left: 40px;">Return the underlying db handle.<br> 75</div> 76<hr width="100%"><span style="font-weight: bold;">> <span 77 style="font-style: italic;">seq </span>get_flags</span><br> 78<div style="margin-left: 40px;">Return the flags set on create.<br> 79</div> 80<hr width="100%"><span style="font-weight: bold;">> <span 81 style="font-style: italic;">seq</span> get_range<br> 82</span> 83<div style="margin-left: 40px;">Return the min and max set at create.<br> 84</div> 85<hr width="100%"><span style="font-weight: bold;">> <span 86 style="font-style: italic;">seq </span>stat<br> 87</span> 88<div style="margin-left: 40px;">Implements the <a 89 href="/docs/seq/seq_stat.html">SEQUENCE->stat</a> function.<br> 90</div> 91<hr width="100%"> 92</body> 93</html> 94