IBM Books

Image, Audio, and Video Extenders Administration and Programming

CREATE QBIC CATALOG


Image Audio Video
X    

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:

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 ]