Read or write a smart large object to or from a file

You can use the SQL functions to read or write a smart large object to or from a file.

You can use the SQL functions FILETOBLOB() and FILETOCLOB() to transfer data from a file to a smart large object. The file can be on a client computer or on a server computer.

You can use the SQL function LOTOFILE() to transfer data from a smart large object to a file. The file might be on a client computer or on a server computer. LOTOFILE() accepts a smart-large-object pointer as a parameter. You can use the smart-large-object pointer structure for this parameter.

For more information about these SQL functions, see the HCL OneDB™ Guide to SQL: Syntax.