IBM Books

Image, Audio, and Video Extenders Administration and Programming

Updater


Image Audio Video
X X X

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

Include file

image
dmbimage.h

audio
dmbaudio.h

video
dmbvideo.h

Syntax

>>-Updater--(--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 person who last updated the image, audio, or video (CHAR(8))

Examples

Get the user ID of the person who last updated the video that is stored in the video column of the employee table for Robert Smith:

EXEC SQL BEGIN DECLARE SECTION;
char hvUpdater[30];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT UPDATER(VIDEO)
     INTO :hvUpdater
     FROM EMPLOYEE
     WHERE NAME='rsmith';


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