IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBiEnableColumn


Image Audio Video
X    

Enables a column for images (DB2Image 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

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

MMDB_RC_NOT_CONNECTED
Application does not have valid connection to a database.

MMDB_RC_WRONG_SIGNATURE
Datatype for the specified column is incorrect. User-defined type MMDBSYS.DB2IMAGE 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 picture column in the employee table for images:

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


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