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