Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

DDLNo324

Suppress/return error upon CREATE of a previously existing index.

Synopsis

[SQL]    DDLNo324=n

Description

The value n may be 1 or 0:

  • If 1 (true) when an attempt is made to CREATE a previously existing index, Caché suppresses the SQLCODE -324 error.

  • If 0 (false) Caché returns the error.

Examples

DDLNo324=0

Range of Values

0 or 1. The default is 0.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Allow DDL CREATE INDEX for Existing Index setting, choose Yes (true) or No (false).

Feedback