ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¾È³»¼­

CREATE DISTINCT TYPE »ç¿ë ¿¹

´ÙÀ½Àº CREATE DISTINCT TYPE »ç¿ë ¿¹ÀÔ´Ï´Ù.

¿¹: ºñ¿ë

´Ù¸¥ ÅëÈ­¸¦ ó¸®ÇÒ ¼ö ÀÖ´Â ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇϰí ÀÖ°í, DB2°¡ Á¶È¸¿¡ À־ ¼­·Î Á÷Á¢ ÀÌ·¯ÇÑ ÅëÈ­¸¦ ºñ±³ ¶Ç´Â Á¶ÀÛÇÒ ¼ö ¾øµµ·Ï ÇÏ·Á ÇÑ´Ù°í °¡Á¤ÇϽʽÿÀ. ´Ù¸¥ ÅëÈ­°ªÀ» ¼­·Î ºñ±³ÇÏ·Á°í ÇÒ ¶§¸¶´Ù º¯È¯ÀÌ ÇÊ¿äÇÕ´Ï´Ù. µû¶ó¼­ ÇÊ¿äÇÑ ¸¸Å­ÀÇ ±¸º° À¯Çü, Áï Ç¥½ÃÇØ¾ß ÇÏ´Â °¢ ÅëÈ­¿¡ ´ëÇØ ±¸º° À¯Çü Çϳª¸¦ Á¤ÀÇÇÕ´Ï´Ù.

     CREATE DISTINCT TYPE US_DOLLAR AS DECIMAL (9,2) WITH COMPARISONS
     CREATE DISTINCT TYPE CANADIAN_DOLLAR AS DECIMAL (9,2) WITH COMPARISONS
     CREATE DISTINCT TYPE EURO AS DECIMAL (9,2) WITH COMPARISONS

DECIMAL(9, 2)¿¡¼­ ºñ±³ ¿¬»êÀÚ°¡ Áö¿øµÇ¹Ç·Î WITH COMPARISONSÀ» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.

¿¹: ÀÛ¾÷ ÀÀ¿ëÇÁ·Î±×·¥

»ç¿ëÀÚ È¸»çÀÇ ±¸Á÷ÀÚ°¡ ÀÛ¼ºÇÑ ¾ç½ÄÀ» DB2 Å×ÀÌºí¿¡ ±â·ÏÇϰí, ÀÌ ¾ç½ÄÀÇ Á¤º¸¸¦ ÃßÃâÇÏ´Â ±â´ÉÀ» »ç¿ëÇÏ·Á ÇÑ´Ù°í °¡Á¤ÇϽʽÿÀ. ÀÌ ±â´ÉÀº (¸®ÅÏÇÒ Á¤º¸¸¦ ãÀ» ¼ö ¾ø¾î) ÀÏ¹Ý ¹®ÀÚ¿­¿¡´Â Àû¿ëÇÒ ¼ö ¾øÀ¸¹Ç·Î ÀÛ¼ºµÈ ¾ç½ÄÀ» Ç¥½ÃÇÏ·Á¸é ±¸º° À¯ÇüÀ» Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù.

     CREATE DISTINCT TYPE PERSONAL.APPLICATION_FORM AS CLOB(32K)

DB2°¡ CLOB¿¡¼­ÀÇ ºñ±³¸¦ Áö¿øÇÏÁö ¾ÊÀ¸¹Ç·Î WITH COMPARISONSÀýÀ» ÁöÁ¤ÇÏÁö ¾Ê½À´Ï´Ù. DBADM ±ÇÇÑÀÌ ÀÖÀ¸¹Ç·Î »ç¿ëÀÚÀÇ ±ÇÇÑ ºÎ¿© ID¿Í ´Ù¸¥ ½ºÅ°¸¶ À̸§À» ÁöÁ¤Çß°í, ±¸Á÷ÀÚ ¾ç½ÄÀ» Ãë±ÞÇÏ´Â ¸ðµç ±¸º° À¯Çü ¹× UDF¸¦ °°Àº ½ºÅ°¸¶·Î ±â·ÏÇÏ·Á ÇÕ´Ï´Ù.


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