The LOCopy function

This function creates a copy of a smart large object.

Syntax

CREATE FUNCTION LOCopy (lob LLD_Lob)
   RETURNS LLD_Lob ;

CREATE FUNCTION LOCopy (lob, LLD_Lob, table_name, CHAR(18),
column_name, CHAR(18))
   RETURNS LLD_Lob;
;

lob

A pointer to the smart large object to copy.

table_name

A table name. This parameter is optional.

column_name

A column name. This parameter is optional.

Usage

This function is an overloaded version of the LOCopy built-in server function. This function is identical to the built-in version of the function, except the first parameter is an lld_lob type rather than a BLOB or CLOB type.

The table_name and column_name parameters are optional. If you specify a table_name and column_name, LOCopy uses the storage characteristics from the specified column_name for the new smart large object that it creates.

If you omit table_name and column_name, LOCopy creates a smart large object with system-specified storage defaults.

See the description of the LOCopy function in the Informix® Guide to SQL: Syntax for complete information about this function.

Return codes

Context