IBM Books

Image, Audio, and Video Extenders Administration and Programming

ENABLE COLUMN


Image Audio Video
X X X

Enables the specified column to store media data.

Authorization

SYSADM, DBADM, Control, Alter

Command syntax

>>-ENABLE COLUMN--table_name--col_name--FOR--extender_name-----><
 

Command parameters

table_name
The name of the table in the current database.

col_name
The name of the column you want to enable.

extender_name
The name of the extender for which you want to enable the table. Valid extender names are db2image, db2audio, and db2video.

Examples

Enable the column photo in table employee to hold image data:

enable column employee photo for db2image

Usage notes

Connect to the database before using this command.


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