Home | Previous Page | Next Page   Object-Relational Databases > Creating and Using Extended Data Types in Dynamic Server > Smart Large Objects >

Copying Smart Large Objects

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.

Table 3. SQL Functions for Smart Large Objects
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

Important:
Casts between BLOB and CLOB data types are not permitted.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]