IBM Books

Image, Audio, and Video Extenders Administration and Programming


Selecting data from a table

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.


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