IBM Books

Image, Audio, and Video Extenders Administration and Programming

DISABLE COLUMN


Image Audio Video
X X X

Disables the specified column from storing the specified media data.

Authorization

SYSADM, DBADM, Control, Alter

Command syntax

>>-DISABLE 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 disable.

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

Examples

Disable the column photo in table employee so that it cannot hold image data:

disable column employee photo for db2image

Usage notes

Connect to the database before using this command.

When you disable a column:


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