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´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.