Simple large objects
A simple large object is a large object that is stored in a blobspace on disk and is not recoverable.
Simple large objects include the TEXT and BYTE data types. The TEXT data type stores any text data. The BYTE data type can store any binary data in an undifferentiated byte stream.
These topics
describe the following information about simple large objects:
- Choosing whether to use a simple large object or a smart large object in your application
- Programming with simple large objects, including how to declare host variables and how to use the locator structure
- Locating simple large objects in memory
- Locating simple large objects in files, both open files and named files
- Locating simple large objects at a user-defined location
- Reading and writing simple large objects to optical disc
The end of this section presents an annotated example program called dispcat_pic. The dispcat_pic sample program demonstrates how to read and display the cat_descr and cat_picture simple-large-object columns from the catalog table of the stores7 demonstration database.
For information about the TEXT and BYTE data types, as well as other SQL data types, see the HCL OneDB™ Guide to SQL: Reference.