Home | Previous Page | Next Page   System Catalog Tables >

SYSBLOBS

The sysblobs system catalog table specifies the storage location of BYTE and TEXT column values. Its name is based on a legacy term for BYTE and TEXT columns, blobs (also known as simple large objects), and does not refer to the BLOB data type of Dynamic Server. The sysblobs table contains one row for each BYTE or TEXT column, and has the following columns.

Column Type Explanation
spacename VARCHAR(128) Name of partition, dbspace, or family
type CHAR(1) Code identifying the type of storage media:
M = Magnetic
O = Optical (IDS)
tabid INTEGER Code identifying the table
colno SMALLINT Column number within its table

A composite index on tabid and colno allows only unique values.

For information about the location and size of chunks of blobspaces, dbspaces, and sbspaces for TEXT, BYTE, BLOB, and CLOB columns, see the IBM Informix: Administrator's Guide and the IBM Informix: Administrator's Reference.

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