Module

From SQL PL Guide for DB2

Module

Modules are supported since DB2 9.7. The conecpt of a modul is similar to the package concept in an Oracle. It's a collection of functions, procedures, types and variables.

It's possible to create your own modules by the CREATE command. Add and remove objects in a module by the ALTER command, or to remove an module by the DROP command.

Also, there a a lot of system defined modules in the database:
- DBMS_ALERT module
- DBMS_DDL module
- DBMS_JOB module
- DBMS_LOB module
- DBMS_OUTPUT module
- DBMS_PIPE module
- DBMS_SQL module
- DBMS_UTILITY module
- MONREPORT module
- UTL_DIR module
- UTL_FILE module
- UTL_MAIL module
- UTL_SMTP module

---

Link to the DB2 Information Center: DB2 9.7