Informix-ESQL/C Programmer's Manual
Chapter 7: Working with INFORMIX-Universal Server Smart Large

Home Contents Index Master Index New Book

In This Chapter

The information in this chapter applies only if you are using Universal Server as your database server.

A smart large object is a large object that is stored in an sbspace on disk, and is recoverable. You can access a smart large object with read, write, and seek operations similar to an operating-system file. Smart large objects include the data types CLOB or BLOB. The CLOB data type stores any kind of text data. The BLOB data type can store any kind of binary data in an undifferentiated byte stream.

This chapter discusses the following information about programming with smart large objects:

Data structures for smart large objects
Creating a smart large object
Accessing a smart large object
Obtaining the status of a smart large object
Reading and writing smart large objects on an optical disc
The ESQL/C API for smart large objects

The end of this chapter presents an example program called create_clob. The create_clob sample program demonstrates how to create a new smart large object from within an ESQL/C program, insert data into a CLOB column of the stores7 database, and then select the smart-large-object data back from this column.

For more information about the CLOB and BLOB data types, as well as other SQL data types, see the Informix Guide to SQL: Reference.

Informix-ESQL/C Programmer's Manual, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.