Image | Audio | Video |
---|---|---|
X | X | X |
Returns the user ID of the person who stored an image, audio, or video in a database table.
Include file
Syntax
>>-Importer--(--handle--)--------------------------------------><
Parameters (data type)
Return values (data type)
User ID of importer (CHAR(8))
Examples
Get the name of all files for audios stored in the sound column of the employee table by user ID rsmith:
EXEC SQL BEGIN DECLARE SECTION; char hvAud_fname[251]; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT FILENAME(SOUND) INTO :hvAud_fname FROM EMPLOYEE WHERE IMPORTER(SOUND)='rsmith';