LOToFile

Home | Previous Page | Next Page Large Object Locator DataBlade Module > Functions > Smart Large Object Functions >

LOToFile

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: is a pointer to the smart large object.
pathname: is a directory path and name of the file to create.
file_dest: is 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 IBM Informix: Guide to SQL Syntax for complete information about this function.

Return Codes

This function returns the value of the new filename.

Context

LOToFile in the IBM Informix: Guide to SQL Syntax