Image, Audio, and Video Extenders Administration and Programming
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:
- The column can not store data for the specified extender. This does
not affect whether other columns in the table are enabled or disabled for
multimedia data types.
- The contents of the column entries are set to NULL and the corresponding
rows in the administrative tables are deleted.
- The triggers associated with the column are dropped.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]