A user retrieves information about how recently Robert Smith's image and voice recording were stored in the employee table.
What the user does: The user gets the information by using an application program that includes the SQL statements that are shown in the following example.
EXEC SQL BEGIN DECLARE SECTION; char[255] hvImg_Time; char[255] hvAud_Time; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT IMPORTTIME(PICTURE), /*when image was stored*/ IMPORTTIME(VOICE) /*when audio was stored*/ INTO :hvImg_Time, :hvAud_Time FROM EMPLOYEE WHERE NAME='Robert Smith'; |
What happens: In response to the ImportTime UDF for the PICTURE column, the Image Extender returns a timestamp that contains the date and time that the image was stored. In response to the ImportTime UDF for the VOICE column, the Audio Extender returns a timestamp that contains the date and time that the voice recording was stored.