docs.intersystems.com
Caché Parameter File Reference
DDLUseSequence
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Search:    

Determines which function a table created by a DDL statement uses for ID assignment.
Synopsis
[SQL]    DDLUseSequence=n
Description
The value n may be 1 or 0:
$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.
Examples
DDLUseSequence=0
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).


Send us comments on this page
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA