Skip to main content


Determines which function a table created by a DDL statement uses for ID assignment.


[SQL]    DDLUseSequence=n


The value n may be 1 or 0:

  • When 1 (true), a table created by DDL CREATE TABLE uses $SEQUENCE for ID assignment.

  • When 0 (false), 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 Caché ObjectScript Reference.



Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Do classes created by a DDL CREATE TABLE statement use $Sequence for ID assignment? setting, choose Yes (true) or No (false).

FeedbackOpens in a new tab