IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBvDisableColumn


Image Audio Video
    X

Disables a column for video (DB2Video data) so that it cannot hold video data. The contents of the column entries are set to NULL, and the metadata associated with this column is dropped. All the triggers defined by the video extender for this column are also dropped. New rows can be inserted into the table that contains the disabled column, and the new rows can include data defined with type DB2Video, but there is no metadata (in the administrative support tables) associated with the new rows. The application must be connected to a database before calling this API.

Authorization

Control, Alter, SYSADM, DBADM

Library file
OS/2 and Windows AIX, HP-UX, and Solaris
dmbvideo.lib libdmbvideo.a (AIX)

libdmbvideo.sl (HP-UX)

libdmbvideo.so (Solaris)

Include file

dmbvideo.h

Syntax

long DBvDisableColumn(
      char *tableName,
      char *colName,
      );

Parameters

tableName (in)
The name of the table that contains the video column.

colName (in)
The name of the video column.

Error codes

MMDB_SUCCESS
API call processed successfully.

MMDB_RC_NO_AUTH
Caller does not have the proper access authority.

MMDB_RC_NOT_CONNECTED
Application does not have valid connection to a database.

Examples

Disable the tv_ads column in the employee table for video (DB2Video data):

#include <dmbvideo.h>
 
rc = DBvDisableColumn("employee",
       "tv_ads");


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