DB2 Version 9.7 for Linux, UNIX, and Windows

System-defined modules simplify SQL PL and application logic

New system-defined modules provide an easy-to-use programmatic interface for performing a variety of application development tasks. A large number of new, pre-written, system defined functions and modules are included in Version 9.7.

The following modules contain routines and procedures that provide enhanced capabilities for communicating through messages and alerts, for creating, scheduling, and managing jobs, for operating on large objects, for executing dynamic SQL, for working with files on the database server file system, and for sending email.

Table 1. Supported modules
Module	Description
DBMS_ALERT module	Provides a set of procedures for registering for alerts, sending alerts, and receiving alerts.
DBMS_JOB module	Provides a set of procedures for creating, scheduling, and managing jobs. DBMS_JOB is an alternate interface for the Administrative Task Scheduler (ATS).
DBMS_LOB module	Provides a set of routines for operating on large objects.
DBMS_OUTPUT module	Provides a set of procedures for putting messages (lines of text) in a message buffer and getting messages from the message buffer within a single session. These procedures are useful during application debugging when you need to write messages to standard output.
DBMS_PIPE module	Provides a set of routines for sending messages through a pipe within or between sessions that are connected to the same database.
DBMS_SQL module	Provides a set of procedures for executing dynamic SQL.
DBMS_UTILITY module	Provides a set of utility routines.
UTL_DIR module	Provides a set of routines for maintaining directory aliases that are used with the UTL_FILE module.
UTL_FILE module	Provides a set of routines for reading from and writing to files on the database server file system.
UTL_MAIL module	Provides a set of procedures for sending email.
UTL_SMTP module	Provides a set of routines for sending email using the Simple Mail Transfer Protocol (SMTP).