Informix-ESQL/C Programmer's Manual
Chapter 10: Working with INFORMIX-Universal Server Opaque
Home
Contents
Index
Master Index
New Book
Accessing Predefined Opaque Data Types
Universal Server implements several built-in data types as
predefined opaque data types
. These data types are opaque data types for which Informix provides the support functions and the database definition. For example, it implements the smart large-object data types,
CLOB
and
BLOB
, as an opaque data type called
clob
and
blob
, respectively. ESQL/C uses the
ifx_lo_t
structure, called an
LO
-pointer, to access the smart large objects. This structure is defined in the
locator.h
header file.
Therefore, you declare ESQL/C host variables for database columns of type
CLOB
or
BLOB
as a
fixed binary
host variable, as follows:
EXEC SQL include locator;
.
.
.
EXEC SQL BEGIN DECLARE SECTION;
fixed binary 'clob' ifx_lo_t clob_loptr;
fixed binary 'blob' ifx_lo_t blob_loptr;
EXEC SQL END DECLARE SECTION;
.
.
.
EXEC SQL select blobcol into :blob_loptr from tab1;
For more information on how to access smart large objects, see
Chapter 7, "Working with INFORMIX-Universal Server Smart Large Objects."
Informix-ESQL/C Programmer's Manual
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
