Skip to main content

DDLNo201

Suppress error upon CREATE of a previously existing table.

Synopsis

[SQL]    No201=n

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

Description

When DDLNo201 is enabled (n = 1), when an attempt is made to CREATE a previously existing table or view, InterSystems IRIS® data platform suppresses the SQLCODE -201 error. When this parameter is not enabled, InterSystems IRIS returns the error.

For further details, refer to the CREATE TABLE and CREATE 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.

You can also change DDLNo201 with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab