Previous Topic: SQL StatementsNext Topic: Statements That Support Procedures and Triggers


Preliminary Information—Lock Levels

In SQL processing, the following statements do not process when the CA Datacom Datadictionary occurrence definition you specify in the statement is protected with a password or Lock Level 1 or 2.

SQL Statement

Occurrence

ALTER

TABLE

DROP

TABLE, VIEW, or SYNONYM

CA Datacom Datadictionary issues a -118 return code and an error message which includes a Datadictionary Service Facility (DSF) return code identifying the problem. See CA Datacom Datadictionary documentation for more information on passwords and lock levels.