IBM Books

Image, Audio, and Video Extenders Administration and Programming

Format


Image Audio Video
X X X

Returns the format of an image, audio, or video.

Include file

image
dmbimage.h

audio
dmbaudio.h

video
dmbvideo.h

Syntax

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

Format of the image, audio, or video (VARCHAR(8). See Table 4 for the supported image, audio, and video formats.

Examples

Get the names of all employees whose images stored in the picture column of the employee table are in GIF format:

EXEC SQL BEGIN DECLARE SECTION;
char hvName[30];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT NAME
     INTO :hvName
     FROM EMPLOYEE
     WHERE FORMAT(PICTURE)='GIF';


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