IBM Books

Image, Audio, Video Extender °ü¸® ¹× ÇÁ·Î±×·¡¹Ö


Å×ÀÌºí¿¡¼­ µ¥ÀÌÅÍ ¼±ÅÃ

»ç¿ëÀÚ´Â Robert SmithÀÇ À̹ÌÁö¿Í À½¼º ·¹ÄÚµùÀÌ ¾ó¸¶³ª ÃÖ±Ù¿¡ Á÷¿ø Å×ÀÌºí¿¡ ÀúÀåµÇ¾ú´ÂÁö¿¡ ´ëÇÑ Á¤º¸¸¦ °Ë»öÇÕ´Ï´Ù.

»ç¿ëÀÚ ¼öÇà ÀÛ¾÷: »ç¿ëÀÚ´Â ´ÙÀ½ ¿¹½Ã¿¡ Ç¥½ÃµÈ SQL¹®À» Æ÷ÇÔÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Á¤º¸¸¦ È®º¸ÇÕ´Ï´Ù.



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';

°á°ú: PICTURE Ä÷³¿ë ImportTime UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender´Â À̹ÌÁö°¡ ÀúÀåµÈ ³¯Â¥¿Í ½Ã°£À» Æ÷ÇÔÇÏ´Â ½Ã°£¼ÒÀÎÀ» ¸®ÅÏÇÕ´Ï´Ù. VOICE Ä÷³¿ë ImportTime UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Audio Extender´Â À½¼º ·¹ÄÚµùÀÌ ÀúÀåµÈ ³¯Â¥¿Í ½Ã°£À» Æ÷ÇÔÇÏ´Â ½Ã°£¼ÒÀÎÀ» ¸®ÅÏÇÕ´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]