The LOToFile function

Copies a smart large object to a file.

Syntax

SQL
CREATE FUNCTION LOToFile(lob LLD_Lob, pathname LVARCHAR,
file_dest CHAR(6)
   RETURNS LVARCHAR;
lob
A pointer to the smart large object.
pathname
A directory path and name of the file to create.
file_dest
The computer on which the file resides. Specify either server or client.

Usage

This function is an overloaded version of the LOToFile built-in server function. This function is identical to the built-in version of the function, except the first parameter is an lld_lob type rather than a BLOB or CLOB type.

See the description of the LOToFile function in the HCL OneDB™ Guide to SQL: Syntax for complete information about this function.

Return codes

This function returns the value of the new file name.

Context

LOToFile in the HCL OneDB Guide to SQL: Syntax.