IBM Books

Image, Audio, and Video Extenders Administration and Programming

CompressType


Image Audio Video
    X

Returns the compression format, such as MPEG-1, of a video.

Include file

dmbvideo.h

Syntax

>>-CompressType--(--handle--)----------------------------------><
 

Parameters (data type)

handle (DB2VIDEO)
Column name or host variable which contains the handle of the video

Return values (data type)

Compression format of the video (VARCHAR(8))

Examples

Get the names of all videos that are stored in the video column of the employee table whose compression format is MPEG-1:

EXEC SQL BEGIN DECLARE SECTION;
 char hvVid_fname[251];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(VIDEO)
     INTO :hvVid_fname
     FROM EMPLOYEE
     WHERE COMPRESSTYPE(VIDEO) = 'MPEG1';


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