IBM Books

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


Å×À̺í Áغñ

DBA´Â Á÷¿ø Å×À̺íÀ» ÀÛ¼ºÇÏ°í ±×°Í°ú »çÁø Ä÷³À» Image Extender¿¡¼­ »ç¿ëÇÒ ¼ö ÀÖµµ·Ï ÇÕ´Ï´Ù.

DBA°¡ ¼öÇàÇÏ´Â ÀÛ¾÷: ÆíÀÇ»ó, DBA´Â ´ÙÀ½°ú °°Àº SQL¹®À» »ç¿ëÇÏ¿© mmdbsys ½ºÅ°¸¶¸¦ ÇöÀç ÇÔ¼ö °æ·Î¿¡ Ãß°¡ÇÕ´Ï´Ù.

SET CURRENT FUNCTION PATH = mmdbsys, CURRENT FUNCTION PATH

À̰ÍÀº UDT¿Í UDF À̸§À» mmdbsys ½ºÅ°¸¶ À̸§À¸·Î ½ÃÀÛÇÏÁö ¾Ê°í ÁöÁ¤ÇÒ ¼ö ÀÖµµ·Ï ÇÕ´Ï´Ù.(mmdbsys ½ºÅ°¸¶´Â ÇÔ¼ö °æ·ÎÀÇ Ã¹¹øÂ° ½ºÅ°¸¶ÀÏ Çʿ䰡 ¾ø½À´Ï´Ù.) UDT¿Í UDF À̸§¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â UDF ¹× UDT À̸§À» ÂüÁ¶ÇϽʽÿÀ.

DBA´Â Á÷¿ø Å×À̺íÀ» ÀÛ¼ºÇÕ´Ï´Ù. DBA´Â DB2 ¸í·ÉÇà 󸮱⸦ »ç¿ëÇÏ¿© ´ÙÀ½ SQL¹®À» ¹ßÇàÇÕ´Ï´Ù.

CREATE TABLE   employee            /*name of the table*/
       (id      CHAR(6)            /*employee identification*/
       name    VARCHAR(40)         /*employee name*/
       picture DB2IMAGE)           /*employee picture*/

±× ´ÙÀ½ DBA´Â db2ext ¸í·ÉÇà 󸮱⸦ »ç¿ëÇÏ¿© ¾Æ·¡ÀÇ ¸í·ÉÀ» ¹ßÇàÇÕ´Ï´Ù.

ENABLE TABLE employee FOR DB2IMAGE 
ENABLE COLUMN employee picture FOR DB2IMAGE

°á°ú: ENABLE TABLE ¸í·É¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.

ENABLE COLUMN ¸í·É¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.


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