IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBvEnableColumn


Image Audio Video
    X

Enables a column for video (DB2Video data). The API defines and manages relationships between this column and the metadata tables. Before calling this API, the application must be connected to a database and the user table must be committed.

Authorization

Control, Alter, SYSADM, DBADM

Use privilege is also required on table spaces and buffer pools specified in the API parameters.

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 DBvEnableColumn(
      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_WARN_ALREADY_ENABLED
Column is already enabled.

MMDB_RC_NOT_CONNECTED
Application does not have valid connection to a database.

MMDB_RC_WRONG_SIGNATURE
Data type for the specified column is incorrect. User-defined data type MMDBSYS.DB2VIDEO is expected.

MMDB_RC_COLUMN_DOESNOT_EXIST
Column is not defined in the specified table.

MMDB_RC_NOT_ENABLED
Database or table is not enabled.

Examples

Enable the video column in the employee table for video:

#include <dmbvideo.h>
 
rc = DBvEnableColumn("employee",
       "video");


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