IBM Books

Image, Audio, and Video Extenders Administration and Programming

Importer


Image Audio Video
X X X

Returns the user ID of the person who stored an image, audio, or video in a database table.

Include file

image
dmbimage.h

audio
dmbaudio.h

video
dmbvideo.h

Syntax

>>-Importer--(--handle--)--------------------------------------><
 

Parameters (data type)

handle (DB2IMAGE, DB2AUDIO, or DB2VIDEO)
Column name or host variable that contains the handle of the image, audio, or video.

Return values (data type)

User ID of importer (CHAR(8))

Examples

Get the name of all files for audios stored in the sound column of the employee table by user ID rsmith:

EXEC SQL BEGIN DECLARE SECTION;
 char hvAud_fname[251];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(SOUND)
     INTO :hvAud_fname
     FROM EMPLOYEE
     WHERE IMPORTER(SOUND)='rsmith';


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