Skip to main content
Previous sectionNext section

DDLNo333

Suppress error upon DROP of a nonexistent index.

Synopsis

[SQL]    DDLNo333=n

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

Description

When DDLNo333 is enabled (n = 1), when an attempt is made to DROP a nonexistent index, InterSystems IRIS® data platform suppresses the SQLCODE -333 error.

For further details, refer to the DROP INDEX command.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Ignore redundant DDL statements to suppress redundant SQLCODE errors.

To set the desired value for DDLNo333 from the InterSystems Terminal, use the SetDDLNo333() method of the %SYSTEM.SQL class. See the class reference for details.

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