Skip to main content


Allow hashed names for globals that store index data of tables created by a DDL statement.


[SQL]    DDLUseExtentSet=n

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


When DDLUseExtentSet is enabled (n = 1), a table created by a DDL CREATE TABLE statement stores its index data in globals that use hashed names. The hashed names typically allow for better performance when running queries against the table, but are less comprehensible to the user. When this parameter is not enabled, the index data is stored in globals named after the class.

Changing This Parameter

To set the desired value for DDLUseExtentSet from the Terminal, use the SetOption(“DDLUseExtentSet”) method of the %SYSTEM.SQL.Util class. See the class reference for details.

You can also change DDLUseExtentSet 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).