IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBaDisableTable


Image Audio Video
  X  

Disables a table for audio (DB2Audio data) so that it cannot hold audio data. All columns in the table that is defined for DB2Audio are also disabled. Some of the metadata that is defined by the Audio Extender for the table is dropped. New rows can be inserted into tables that are defined with type DB2Audio, 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. It is recommended that after calling this API you issue an SQL COMMIT statement.

Authorization

Control, Alter, SYSADM, DBADM

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 DBaDisableTable(
      char *tableName
      );

Parameters

tableName (in)
The name of the table that contains an audio 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 employee table for audio (DB2Audio data):

#include <dmbaudio.h>
 
rc = DBaDisableTable("employee");


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