Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\reference\sqlsupport.12.10.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Create Sequence</title> <link rel="StyleSheet" href="css/sqlsupport.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="sqlsupport.12.01.html#139599">10 SQL Statements and Extensions for the Salesforce Driver</a> : Create Sequence</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="139599">Create Sequence</a></div> <div class="Body"><a name="108849">The Create Sequence statement creates an auto-incrementing sequence for a local table.</a></div> <div class="gutter_text_right"><a name="108604">Grammar</a></div> <div class="syntax_first"><a name="108605">CREATE SEQUENCE </a><span class="EquationVariables">sequence_name</span> [AS {INTEGER | BIGINT}] [START WITH <span class="EquationVariables">start_value</span>] [INCREMENT BY <span class="EquationVariables">increment_value</span>]</div> <div class="Body"><a name="108606">where:</a></div> <div class="Body"><span class="EquationVariables"><a name="108607">sequence_name</a></span> specifies the name of the sequence. By default, the sequence type is INTEGER.</div> <div class="Body"><span class="EquationVariables"><a name="108608">start_value</a></span> specifies the starting value of the sequence. The default start value is 0.</div> <div class="Body"><span class="EquationVariables"><a name="158049">increment_value</a></span> specifies the value of the increment; the value must be a positive integer. The default increment is 1.</div> <div class="head_2_no_TOC"><a name="175837">Next Value For Clause</a></div> <div class="Body"><a name="175838">Use the Next Value For clause to specify the next value for a sequence that is used in a </a>Select, Insert, or Update statement.</div> <div class="gutter_text_right"><a name="158017">Grammar</a></div> <div class="syntax_first"><a name="158018">NEXT VALUE FOR </a><span class="EquationVariables">sequence_name</span></div> <div class="Body"><a name="158019">where </a><span class="EquationVariables">sequence_name</span> specifies the name of the sequence from which to retrieve the value.</div> <div class="gutter_text_right"><a name="175845">Example</a></div> <div class="Body"><a name="175851">The following example retrieves the next value or set of values in Sequence1:</a></div> <div class="syntax_first"><a name="175852">SELECT NEXT VALUE FOR Sequence1 FROM Account</a></div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de