Previous Topic: DESCRIBE CURSORNext Topic: DROP CALC

Statements › DROP ACCESS MODULE

DROP ACCESS MODULE

The DROP ACCESS MODULE access module management statement deletes an access module and its definition from the dictionary. It is also a CA IDMS extension of the SQL standard.

Authorization

To issue a DROP ACCESS MODULE statement, you must hold the DROP privilege on or own the access module named in the statement.

Syntax
►►─── DROP ACCESS MODULE ─────────────────────────────────────────────────────►

 ►─┬────────────────┬─ access-module-name ────────────────────────────────────►
   └─ schema-name. ─┘

 ►─┬─────────────────────────────┬────────────────────────────────────────────►
   └─ VERSION am-version-number ─┘

 ►─┬────────────┬─────────────────────────────────────────────────────────────►◄
   └─ PRESERVE ─┘
Parameters
access-module-name

Specifies the name of the access module being dropped. Access-module-name must identify an access module defined and stored in the dictionary.

schema-name

Identifies the schema associated with the specified version of the named access module.

If you do not specify schema-name, it defaults to the current schema associated with your SQL session.

VERSION am-version-number

Specifies the version number of the access module being dropped.

If VERSION is not specified, am-version-number defaults to 1.

PRESERVE

Directs CA IDMS to retain privileges held on the access module being dropped. If you subsequently create a new access module with the same name as the access module being dropped, the preserved privileges will apply to the new access module.

If you do not specify PRESERVE in a DROP ACCESS MODULE statement, CA IDMS deletes all privileges held on the access module if CA IDMS internal security is in effect.

Example

Dropping an Access Module

The following DROP ACCESS MODULE statement deletes version 1 of the SALES001 access module from the dictionary but retains privileges held on the access module:

drop access module test.sales001
   preserve;
More Information