DDLNo30
Suppress/return error upon DROP of a nonexistent table.
Synopsis
[SQL] DDLNo30=n
Description
The value n may be 1 or 0:
-
If 1 (true) when an attempt is made to DROP a nonexistent table, Caché suppresses the SQLCODE -30 error.
-
If 0 (false) Caché returns the error.
Examples
DDLNo30=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 DROP of Non-existent Table setting, choose Yes (true) or No (false).