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