DDLUseSequence
Synopsis
[SQL] DDLUseSequence=n
n is either 1 or 0. The default value is 1.
Description
When DDLUseSequence is enabled (n = 1), a table created by DDL CREATE TABLE uses $SEQUENCE for ID assignment. When this parameter is not enabled, the table uses $INCREMENT.
$SEQUENCE is the default function, and is better suited for ID assignment. For a comparison of the two functions, see the $INCREMENT or $SEQUENCE section in the chapter “$INCREMENT” in ObjectScript Reference.
Changing This Parameter
To set the desired value for DDLUseSequence from the Terminal, use the SetOption(“DDLUseSequence”) method of the %SYSTEM.SQL.Util class. See the class reference for details.
You can also change DDLUseSequence with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).