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

1 
2.1 FILETOBLOB
2.1 FILETOCLOB
1 (
1 'pathname'
1 ,
1 'file_destination'
1?  , 'table' , 'column'
1 )
1  LOTOFILE (
2.1 BLOB_column
2.1 CLOB_column
1 ,
1 'pathname'
1 ,
1 'file_destination'
1 )
1  LOCOPY (
2.1 BLOB_column
2.1 CLOB_column
1?  , 'table' , 'column'
1 )
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