IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBaEnableColumn


Image Audio Video
  X  

Enables a column for audio (DB2Audio 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. It is recommended that after calling this API you issue an SQL COMMIT statement.

Authorization

Control, Alter, SYSADM, DBADM

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

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

libdmbaudio.sl (HP-UX)

libdmbaudio.so (Solaris)

Include file

dmbaudio.h

Syntax

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

Parameters

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

colName (in)
The name of the audio 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_WRONG_SIGNATURE
Data type for the specified column is incorrect. User-defined data type MMDBSYS.DB2AUDIO is expected.

MMDB_RC_COLUMN_DOESNOT_EXIST
Column is not defined in the specified table.

MMDB_RC_NOT_CONNECTED
Application does not have valid connection to a database.

MMDB_RC_NOT_ENABLED
Database or table is not enabled.

Examples

Enable the sound column in the employee table for audio (DB2Audio data):

#include <dmbaudio.h>
 
rc = DBaEnableColumn("employee", "sound");


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