Copy smart large objects
HCL Informix® provides
functions that you can call from within an SQL statement to import
and export smart large objects. The following table shows the smart-large-object
functions.
| Function Name | Purpose |
|---|---|
| FILETOBLOB() | Copies a file into a BLOB column |
| FILETOCLOB() | Copies a file into a CLOB column |
| LOCOPY() | Copies BLOB or CLOB data into another BLOB or CLOB column |
| LOTOFILE() | Copies BLOB or CLOB data into a file |
For detailed information and the syntax of smart-large-object functions, see the Expression segment in the HCL Informix Guide to SQL: Syntax.
Restriction: Casts between BLOB and CLOB data types are not
permitted.