Restrictions on modules

Restrictions on the use of modules are good to note before defining modules or when troubleshooting problems related to their use.

The following restrictions apply to the use of modules:
  • Granting privileges on individual objects within a module is not supported. Only the EXECUTE privilege can be granted on or revoked from the module.
  • By definition, modules can only include definitions of the following database objects:
    • SQL procedures
    • SQL functions
    • External procedures
    • External functions
    • Created conditions
    • A module initialization procedure for implicit execution upon module initialization
    • User-defined data type definitions including: distinct type, array type, associative array type, row type, and cursor type
    • Global variables of all data types
  • By definition, the SYS_INIT initialization procedure which is used to initialize a module cannot reference parameters or return result sets.
  • Defining, altering, initializing or dropping modules is not supported from IBM® Data Studio tools.
In this version, the following restrictions apply to the use of modules:
  • Definition and execution of the initialization procedure is not supported.