(C) IBM Corp. 1996, 1999
Text Extender: Administration and Programming
The FILE function does one of the following:
- Returns the path and file name in a handle
- Changes the path and file name in a handle, and returns the path and file
name.
The returned handle is a value of type DB2TEXTFH.
Function syntax
>>-FILE--(--handle--)------------------------------------------><
>>-FILE--(--handle--,--file-name--)----------------------------><
Function parameters
- handle
- An expression whose result is a value of type DB2TEXTFH. It is
usually the name of a handle column from which the file name is to be
returned.
- file-name
- A string of type VARCHAR(150) specifying the new absolute path and file
name of the external file that is to be associated with the handle. The
path could be, for example, a LAN drive or an NFS-mounted drive. The
file access permissions must permit access to the file by the DB2 UDB instance
owner.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]