Dynamic Server provides functions that you can call from within an SQL statement to import and export smart large objects. Table 3 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 IBM Informix: Guide to SQL Syntax