Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

FILE

The FILE function does one of the following:

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 ]