Image | Audio | Video |
---|---|---|
X |
Disables a column for audio (DB2Audio data) so that it cannot hold audio 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 audio 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 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 DBaDisableColumn( char *tableName, char *colName, );
Parameters
Error codes
Examples
Disable the sound column in the employee table for audio (DB2Audio data):
#include <dmbaudio.h> rc = DBaDisableColumn("employee", "sound");