Home | Previous Page | Next Page   Large Object Locator DataBlade Module > Functions > Smart Large Object Functions >

LOCopy

This function creates a copy of a smart large object.

Syntax

SQL
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
is a pointer to the smart large object to copy.
table_name
is a table name. This parameter is optional.
column_name
is 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 IBM Informix: Guide to SQL Syntax for complete information about this function.

Return Codes

This function returns a pointer to the new lld_lob value.

Context

LOCopy in the IBM Informix: Guide to SQL Syntax

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]