ALLBASE/SQL Reference Manual (36216-90216)

402 Chapter10
SQL Statements A - D
DROP MODULE
Examples
1. Dropping preprocessed application programs
A module for the application program MyProg is created and stored in the system
catalog by one of the preprocessors.
GRANT RUN ON MyProg TO PUBLIC
DROP MODULE MyProg PRESERVE
Authorization information for MyProg is retained, but the module is deleted from the
system catalog. You can re-preprocess MyProg and not have to redefine its
authorization.
2. Dropping interactively prepared modules
Two sections for a module named Statistics are stored in the system catalog.
PREPARE Statistics (1)
FROM 'UPDATE STATISTICS FOR TABLE PurchDB.Orders'
PREPARE Statistics (2)
FROM 'UPDATE STATISTICS FOR TABLE PurchDB.OrderItems'
This only executes Statistics(1). The statistics for table PurchDB.Orders are updated:
EXECUTE Statistics
The statistics for table PurchDB.OrderItems are updated:
EXECUTE Statistics(2)
Both sections of the module are deleted.
DROP MODULE Statistics