DB2 Version 9.7 for Linux, UNIX, and Windows

UTL_DIR module

The UTL_DIR module provides a set of routines for maintaining directory aliases that are used with the UTL_FILE module.

Note: The UTL_DIR module does not issue any direct operating system calls, for example, the mkdir or rmdir commands. Maintenance of the physical directories is outside the scope of this module.

The schema for this module is SYSIBMADM.

The UTL_DIR module includes the following system-defined routines.

Table 1. System-defined routines available in the UTL_DIR module
Routine name	Description
CREATE_DIRECTORY procedure	Creates a directory alias for the specified path.
CREATE_OR_REPLACE_DIRECTORY procedure	Creates or replaces a directory alias for the specified path.
DROP_DIRECTORY procedure	Drops the specified directory alias.
GET_DIRECTORY_PATH procedure	Gets the corresponding path for the specified directory alias.