Image | Audio | Video |
---|---|---|
X | X | X |
Returns the format of an image, audio, or video.
Include file
Syntax
>>-Format--(--handle--)----------------------------------------><
Parameters (data type)
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';