Image, Audio, and Video Extenders Administration and Programming
Creates a QBIC catalog in the current database for the specified DB2IMAGE
column. The extender automatically generates the catalog name.
Authorization
Alter, Control, SYSADM, DBADM
Command syntax
>>-CREATE QBIC CATALOG--table_name--column_name----+-OFF-+-----><
'-ON--'
Command parameters
- table_name
- The name of the DB2IMAGE enabled table.
- column_name
- The name of the DB2IMAGE enabled column.
- OFF
- Images are manually cataloged.
- ON
- Images are automatically cataloged.
- tablespace_name
- The table space specification and index options for the QBIC
Catalog. The specification has four parts:
- The name of the table space for the catalog tables that contain feature
data. The table space must be specified. The table space should
be a segmented table space.
- For the index created on the catalog tables, any combination of the
using-block, free block, gbpcache-block, or index options for type 2
non-partitioned indexes. This specification is optional. You get
defaults if you do not specify this part.
- The name of the table space for the catalog log table. The table
space can be a simple table space or a segmented table space. This
specification is optional. If you do not specify a table space for the
log table, the table space specified for the feature data tables is
used.
- For the index created on the log data table, any combination of the
using-block, free block, gbpcache-block, or index options for type 2
non-partitioned indexes. This specification is optional. You get
defaults if you do not specify this part.
Examples
Create a QBIC catalog for the picture column in the employee table, with
auto-cataloging set ON:
create qbic catalog employee picture on
Usage notes
If you specify ON, the images imported into the column are automatically
cataloged into the associated QBIC catalog. The default is OFF.
Connect to the database before using this command.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]