IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBiDisableColumn


Image Audio Video
X    

Disables a column for images (DB2Image data) so that it cannot hold image data. The contents of the column entries are set to NULL, and the metadata associated with this column is dropped. The QBIC catalog that is associated with this column is also deleted. All the triggers defined by the image 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 DB2Image, 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
dmbimage.lib libdmbimage.a (AIX)

libdmbimage.sl (HP-UX)

libdmbimage.so (Solaris)

Include file

dmbimage.h

Syntax

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

Parameters

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

colName (in)
The name of the image 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 picture column in the employee table for images (DB2Image data):

#include <dmbimage.h>
 
rc = DBiDisableColumn("employee",
       "picture");


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