Smart-Large-Object Functions
The smart-large-object functions support objects of BLOB and CLOB data types:
The smart-large-object functions have the following syntax:
Smart-Large-Object Functions
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| BLOB_column, CLOB_column | A column of type BLOB; a column of type CLOB | The column data type must be BLOB or CLOB | Identifier |
| column | Column within table for the copy of the BLOB or CLOB value | Must have CLOB or BLOB as its data type | Quoted String |
| file_destination | The system on which to put or get the smart large object | The only valid values are the strings 'server' or 'client' |
Quoted String |
| pathname | Directory path and filename to locate the smart large object | No more than 256 bytes. Must exist on file_destination system. See also Pathnames with Commas. | Quoted String |
| table | Table containing column for the copy of the BLOB or CLOB value | A comma (not a period) separates the 'table' and 'column' arguments | Quoted String |