Skip to main content
Previous sectionNext section

DDLNo30

Suppress error upon DROP of a nonexistent table.

Synopsis

[SQL]    DDLNo30=n

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

Description

When DDLNo30 is enabled (n = 1), when an attempt is made to DROP a nonexistent table, InterSystems IRIS® data platform suppresses the SQLCODE -30 error. When this parameter is not enabled, InterSystems IRIS returns the error.

For further details, refer to the DROP TABLE and DROP VIEW commands.

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 DDLNo30 from the InterSystems Terminal, use the SetDDLNo30() method of the %SYSTEM.SQL class. See the class reference for details.

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