IBM Books

Image, Audio, and Video Extenders Administration and Programming

Size


Image Audio Video
X X X

Returns the size of an image, audio, or video, in bytes.

Include file

image
dmbimage.h

audio
dmbaudio.h

video
dmbvideo.h

Syntax

>>-Size--(--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)

Size, in bytes, of image, audio, or video (INTEGER).

Examples

Get the file name of all images in the picture column of the employee table whose size is greater than 310 KB:

EXEC SQL BEGIN DECLARE SECTION;
 char hvImg_fname[251];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(PICTURE)
     INTO :hvImg_fname
     FROM EMPLOYEE
     WHERE SIZE(PICTURE) > 310000;


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