DROP CALC

The DROP CALC data description statement deletes the definition of a CALC key from the dictionary. It is also a CA IDMS extension of the SQL standard.
idmscu19
The DROP CALC data description statement deletes the definition of a CALC key from the dictionary. It is also a CA IDMS extension of the SQL standard.
Authorization
To issue a DROP CALC statement, you must own or have the ALTER privilege on the table on which the CALC key is defined.
Syntax
  ►►─── DROP CALC key FROM ─┬────────────────┬─ 
table-identifier
 ───────────────►◄                           └─ 
schema-name
. ─┘  
Parameters
  • FROM
    table-identifier
    Specifies the name of the table associated with the CALC key being dropped.
    Table-identifier
    must identify a base table on which a CALC key has been defined in the dictionary. The named table cannot contain any data (that is, the table must be empty).
  • schema-name
    Identifies the schema associated with the named table.
    If you do not specify
    schema-name
    , it defaults to:
    • The current schema associated with your SQL session, if the statement is entered through the Command Facility or executed dynamically
    • The schema associated with the access module used at runtime, if the statement is embedded in an application program
Usage
CALC Keys on Tables in the SYSTEM Schema
You cannot delete the definition of a CALC key on a table in the SYSTEM schema.
CALC Keys in the Implementation of Referential Constraints
You cannot drop a CALC key that is used in the implementation of a referential constraint if no existing index can be used in place of the CALC key.
Example
Dropping a CALC Key
The following DROP CALC statement deletes the definition of the CALC key associated with the COVERAGE table from the dictionary:
drop calc from coverage;
More Information
  • For more information about defining CALC keys, see CREATE CALC.
  • For more information about unlinked referential constraints, see CREATE CONSTRAINT.