Skip to main content


Specify the function a table created by a DDL statement uses for ID assignment.


[SQL]    DDLUseSequence=n

n is either 1 or 0. The default value is 1.


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 $INCREMENT or $SEQUENCE.

Changing This Parameter

To set the desired value for DDLUseSequence from the Terminal, use the SetOption(“DDLUseSequence”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change DDLUseSequence with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab