´ÙÀ½Àº 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¸¦ °°Àº ½ºÅ°¸¶·Î ±â·ÏÇÏ·Á ÇÕ´Ï´Ù.