DB2 Version 9.7 for Linux, UNIX, and Windows

GET_DIRECTORY_PATH procedure - Get the path for a directory alias

The GET_DIRECTORY_PATH procedure returns the corresponding path for a directory alias.

Syntax


>>-UTL_DIR.GET_DIRECTORY_PATH--(--alias--,--path--)------------><

alias: An input argument of type VARCHAR(128) that specifies the directory alias.
path: An output argument of type VARCHAR(1024) that specifies the path that is defined for a directory alias.

EXECUTE privilege on the UTL_DIR module.

Get the path that is defined for a directory alias.

CALL UTL_DIR.GET_DIRECTORY_PATH('mydir', ? )@

This example results in the following output:

  Value of output parameters
  --------------------------
  Parameter Name  : PATH
  Parameter Value : home/rhoda/temp/mydir

  Return Status = 0