|>>-MQPUBLISH--(-------------------------------------------------> | |>--+---------------------------------------------+--msg-data----> | '-publisher-service--,--+-------------------+-' | '-service-policy--,-' | |>--+---------------------------------+--)---------------------->< | '-,--topic--+-------------------+-' | | (1) | | '-,--correl-id------' | |
|ÁÖ:
|½ºÅ°¸¶´Â DB2MQÀÔ´Ï´Ù.
|MQPUBLISH ÇÔ¼ö´Â µ¥ÀÌÅ͸¦ MQSeries¿¡ ¹ßÇàÇÕ´Ï´Ù. |ÀÌ ÇÔ¼ö¸¦ »ç¿ëÇÏ·Á¸é MQSeries Publish/Subscribe³ª MQSeries Integrator Áß Çϳª¸¦ |¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. |ÀÚ¼¼ÇÑ Á¤º¸´Â www.ibm.com/software/MQSeries¸¦ ÂüÁ¶ÇϽʽÿÀ.
|MQPUBLISH ÇÔ¼ö´Â service-policy°¡ Á¤ÀÇÇÑ ¼ºñ½º ±ÔÁ¤ Ç°ÁúÀ» »ç¿ëÇÏ¿© |msg-data¿¡ Æ÷ÇÔµÈ µ¥ÀÌÅ͸¦ publisher-service¿¡ ÁöÁ¤µÈ |MQSeries ¹ßÇàÀÚ¿¡ ¹ßÇàÇÕ´Ï´Ù. |¼±ÅÃÀûÀ¸·Î ¸Þ½ÃÁö¿¡ ÁÖÁ¦¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ°í, »ç¿ëÀÚ Á¤ÀÇ ¸Þ½ÃÁö »ó°ü ID¸¦ ÁöÁ¤ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. |ÀÌ ÇÔ¼ö´Â ¼º°øÇÒ °æ¿ì "1"°ªÀ» ¸®ÅÏÇÏ°í, ¼º°øÇÏÁö ¸øÇÒ °æ¿ì "0"°ªÀ» ¸®ÅÏÇÕ´Ï´Ù. |
|¿¹
|¿¹ 1: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© ¹®ÀÚ¿ "Testing 123"À» |±âº» publisher ¼ºñ½º(DB2.DEFAULT.PUBLISHER)¿¡ ¹ßÇàÇÕ´Ï´Ù. |¸Þ½ÃÁö¿¡ »ó°ü ID³ª ÁÖÁ¦´Â ÁöÁ¤µÇÁö ¾Ê½À´Ï´Ù.
|VALUES MQPUBLISH('Testing 123')
|¿¹ 2: ÀÌ ¿¹¿¡¼´Â "TESTS"¶ó´Â ÁÖÁ¦ ÇÏ¿¡ ¹®ÀÚ¿ "Testing 345"¸¦ |"MYPUBLISHER" publisher ¼ºñ½º¿¡ ¹ßÇàÇÕ´Ï´Ù. ±âº» ±ÔÁ¤ÀÌ »ç¿ëµÇ°í |»ó°ü ID´Â ÁöÁ¤µÇÁö ¾Ê½À´Ï´Ù.
|VALUES MQPUBLISH('MYPUBLISHER','Testing 345', 'TESTS')
|¿¹ 3: ÀÌ ¿¹¿¡¼´Â »ó°ü ID¸¦ "TEST1"·Î ÁöÁ¤ÇÏ°í "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© ¹®ÀÚ¿ |"Testing 678"À» "MYPUBLISHER" publisher ¼ºñ½º¿¡ ¹ßÇàÇÕ´Ï´Ù. |ÀÌ ¸Þ½ÃÁö´Â "TESTS"¶ó´Â ÁÖÁ¦·Î ¹ßÇàµË´Ï´Ù.
|VALUES MQPUBLISH('MYPUBLISHER','MYPOLICY','Testing 678','TESTS','TEST1')
|¿¹ 4: ÀÌ ¿¹¿¡¼´Â »ó°ü ID´Â ÁöÁ¤ÇÏÁö ¾Ê°í ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |"TESTS"¶ó´Â ÁÖÁ¦ ÇÏ¿¡ ¹®ÀÚ¿ "Testing 901"À» "MYPUBLISHER" publisher ¼ºñ½º¿¡ ¹ßÇàÇÕ´Ï´Ù.
|VALUES MQPUBLISH('Testing 901','TESTS')
|¼º°øÇÒ °æ¿ì, ¸ðµç ¿¹´Â '1'°ªÀ» ¸®ÅÏÇÕ´Ï´Ù.
|>>-MQREADCLOB--(--+----------------------------------------+----> | '-receive-service--+-------------------+-' | '-,--service-policy-' | |>--)----------------------------------------------------------->< | |
|½ºÅ°¸¶´Â DB2MQÀÔ´Ï´Ù.
|MQREADCLOB ÇÔ¼ö´Â service-policy°¡ Á¤ÀÇÇÑ ¼ºñ½º ±ÔÁ¤ Ç°ÁúÀ» »ç¿ëÇÏ¿© |receive-service°¡ ÁöÁ¤ÇÑ MQSeries À§Ä¡¿¡¼ ¸Þ½ÃÁö¸¦ ¸®ÅÏÇÕ´Ï´Ù. |ÀÌ ÀÛ¾÷À» ½ÇÇàÇÏ¸é ´ë±âÇà·Ä¿¡¼ receive-service¿Í ¿¬°üµÈ ¸Þ½ÃÁö°¡ Á¦°ÅµÇÁö ¾Ê°í, |´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö°¡ ¸®Åϵ˴ϴÙ. |¸®ÅÏ°ªÀº ¸Þ½ÃÁö¸¦ Æ÷ÇÔÇÏ´Â, ÃÖ´ë ±æÀÌ°¡ IMBÀÎ CLOBÀÔ´Ï´Ù. ¸®ÅÏÇÒ ¸Þ½ÃÁö°¡ ¾øÀ» ¶§´Â ³Î(NULL)ÀÌ |¸®Åϵ˴ϴÙ. |
|¿¹:
|¿¹ 1: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© ±âº» |¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö¸¦ ÀнÀ´Ï´Ù.
|VALUES MQREADCLOB()
|¿¹ 2: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |"MYSERVICE" ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö¸¦ ÀнÀ´Ï´Ù.
|VALUES MQREADCLOB('MYSERVICE')
|¿¹ 3: ÀÌ ¿¹¿¡¼´Â "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© "MYSERVICE" ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö¸¦ ÀнÀ´Ï´Ù.
|VALUES MQREADCLOB('MYSERVICE','MYPOLICY')
|¼º°øÇÒ °æ¿ì, ¸ðµç ¿¹´Â ¸Þ½ÃÁö ³»¿ëÀ» ÃÖ´ë Å©±â°¡ 1MBÀÎ CLOBÀ¸·Î ¸®ÅÏÇÕ´Ï´Ù. |¸®ÅÏÇÒ ¸Þ½ÃÁö°¡ ¾øÀ» ¶§´Â ³Î(NULL)ÀÌ ¸®Åϵ˴ϴÙ.
|>>-MQRECEIVECLOB------------------------------------------------> | |>--(--+----------------------------------------------------------+--)->< | '-receive-service--+-------------------------------------+-' | '-,--service-policy--+--------------+-' | '-,--correl-id-' | |
|½ºÅ°¸¶´Â DB2MQÀÔ´Ï´Ù.
|MQRECEIVECLOB ÇÔ¼ö´Â service-policy°¡ Á¤ÀÇÇÑ ¼ºñ½º ±ÔÁ¤ Ç°ÁúÀ» »ç¿ëÇÏ¿© |receive-service°¡ ÁöÁ¤ÇÑ MQSeries À§Ä¡¿¡¼ ¸Þ½ÃÁö¸¦ ¸®ÅÏÇÕ´Ï´Ù. ÀÌ |ÀÛ¾÷À» ¼öÇàÇϸé receive-service¿Í ¿¬°üµÈ ´ë±âÇà·Ä¿¡¼ ¸Þ½ÃÁö°¡ Á¦°ÅµË´Ï´Ù. |correl-id°¡ ÁöÁ¤µÇ¾î ÀÖÀ¸¸é ÀÏÄ¡ÇÏ´Â »ó°ü ID°¡ Àִ ù ¹ø° ¸Þ½ÃÁö°¡ ¸®Åϵ˴ϴÙ. |correl-id°¡ ÁöÁ¤µÇ¾î ÀÖÁö ¾ÊÀ¸¸é ´ë±âÇà·Ä Çìµå¿¡ |ÀÖ´Â ¸Þ½ÃÁö°¡ ¸®Åϵ˴ϴÙ. |¸®ÅÏ°ªÀº ¸Þ½ÃÁö¸¦ Æ÷ÇÔÇÏ´Â, ÃÖ´ë ±æÀÌ°¡ IMBÀÎ CLOBÀÔ´Ï´Ù. |¸®ÅÏÇÒ ¸Þ½ÃÁö°¡ ¾øÀ» ¶§´Â ³Î(NULL)ÀÌ |¸®Åϵ˴ϴÙ. |
|¿¹:
|¿¹ 1: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© ±âº» |¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù.
|VALUES MQRECEIVECLOB()
|¿¹ 2: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |"MYSERVICE" ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù.
|VALUES MQRECEIVECLOB('MYSERVICE')
|¿¹ 3: ÀÌ ¿¹¿¡¼´Â "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© "MYSERVICE" ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù.
|VALUES MQRECEIVECLOB('MYSERVICE','MYPOLICY')
|¿¹ 4: ÀÌ ¿¹¿¡¼´Â "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© "MYSERVICE" ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·Ä Çìµå¿¡¼ '1234'¿Í ÀÏÄ¡ÇÏ´Â »ó°ü ID°¡ Àִ ù ¹ø° ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù.
|VALUES MQRECEIVECLOB('MYSERVICE',MYPOLICY','1234')
|¼º°øÇÒ °æ¿ì, ¸ðµç ¿¹´Â ¸Þ½ÃÁö ³»¿ëÀ» ÃÖ´ë Å©±â°¡ 1MBÀÎ CLOBÀ¸·Î ¸®ÅÏÇÕ´Ï´Ù. |¸®ÅÏÇÒ |¸Þ½ÃÁö°¡ ¾øÀ» ¶§´Â ³Î(NULL)ÀÌ ¸®Åϵ˴ϴÙ.
|>>-MQSEND--(--+----------------------------------------+--------> | '-send-service--,--+-------------------+-' | '-service-policy--,-' | |>--msg-data--+-------------------+--)-------------------------->< | | (1) | | '-,--correl-id------' | |
|ÁÖ:
|½ºÅ°¸¶´Â DB2MQÀÔ´Ï´Ù.
|MQSEND ÇÔ¼ö´Â service-policy°¡ Á¤ÀÇÇÑ ¼ºñ½º ±ÔÁ¤ Ç°ÁúÀ» »ç¿ëÇÏ¿© |msg-data¿¡ Æ÷ÇÔµÈ µ¥ÀÌÅ͸¦ send-service°¡ ÁöÁ¤ÇÑ MQSeries·Î ¼Û½ÅÇÕ´Ï´Ù. |correl-id·Î ¼±ÅÃÀû »ç¿ëÀÚ Á¤ÀÇ ¸Þ½ÃÁö »ó°ü ID¸¦ ÁöÁ¤ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. |ÀÌ ÇÔ¼ö´Â ¼º°øÇÒ °æ¿ì "1"°ªÀ» ¸®ÅÏÇÏ°í, ¼º°øÇÏÁö ¸øÇÒ °æ¿ì "0"°ªÀ» ¸®ÅÏÇÕ´Ï´Ù. |
|¿¹:
|¿¹ 1: ÀÌ ¿¹¿¡¼´Â »ó°ü ID¸¦ ÁöÁ¤ÇÏÁö ¾Ê°í ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |¹®ÀÚ¿ "Testing 123"À» ±âº» ¼ºñ½º(DB2.DEFAULT.SERVICE)¿¡ ¼Û½ÅÇÕ´Ï´Ù.
|VALUES MQSEND('Testing 123')
|¿¹ 2: ÀÌ ¿¹¿¡¼´Â »ó°ü ID¸¦ ÁöÁ¤ÇÏÁö ¾Ê°í "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© |¹®ÀÚ¿ "Testing "345"¸¦ "MYSERVICE" ¼ºñ½º¿¡ ¼Û½ÅÇÕ´Ï´Ù.
|VALUES MQSEND('MYSERVICE','MYPOLICY','Testing 345')
|¿¹ 3: ÀÌ ¿¹¿¡¼´Â »ó°ü ID¸¦ "TEST3"À¸·Î ÁöÁ¤ÇÏ°í "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© |¹®ÀÚ¿ "Testing 678"À» "MYSERVICE" ¼ºñ½º¿¡ ¼Û½ÅÇÕ´Ï´Ù.
|VALUES MQSEND('MYSERVICE','MYPOLICY','Testing 678','TEST3')
|¿¹ 4: ÀÌ ¿¹¿¡¼´Â »ó°ü ID¸¦ ÁöÁ¤ÇÏÁö ¾Ê°í ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |¹®ÀÚ¿ "TESTING 901"À» "MYSERVICE" ¼ºñ½º¿¡ ¼Û½ÅÇÕ´Ï´Ù.
|VALUES MQSEND('MYSERVICE','Testing 901')
|¼º°øÇÒ °æ¿ì, ¸ðµç ¿¹´Â '1' ½ºÄ®¶ó °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.
|>>-MQREADALLCLOB--(---------------------------------------------> | |>--+----------------------------------------+--+----------+-----> | '-receive-service--+-------------------+-' '-num-rows-' | '-,--service-policy-' | |>--)----------------------------------------------------------->< | |
|½ºÅ°¸¶´Â DB2MQÀÔ´Ï´Ù.
|MQREADALLCLOB ÇÔ¼ö´Â service-policy ¼ºñ½º ±ÔÁ¤ Ç°ÁúÀ» »ç¿ëÇÏ¿© receive-service°¡ |ÁöÁ¤ÇÑ MQSeries À§Ä¡¿¡¼ ¸Þ½ÃÁö¿Í ¸Þ½ÃÁö ¸ÞŸµ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ Å×À̺íÀ» ¸®ÅÏÇÕ´Ï´Ù. |ÀÌ ÀÛ¾÷À» ¼öÇàÇÏ¸é ´ë±âÇà·Ä¿¡¼ receive-service¿Í ¿¬°üµÈ |¸Þ½ÃÁö°¡ Á¦°ÅµÇÁö ¾Ê½À´Ï´Ù.
|num-rows°¡ ÁöÁ¤µÇ¾î ÀÖÀ¸¸é num-rows ¸Þ½ÃÁöÀÇ ÃÖ´ë Å©±â°¡ ¸®Åϵ˴ϴÙ. |num-rows°¡ ÁöÁ¤µÇ¾î ÀÖÁö ¾ÊÀ¸¸é »ç¿ë °¡´ÉÇÑ ¸ðµç ¸Þ½ÃÁö°¡ ¸®Åϵ˴ϴÙ. |¸®ÅÏµÈ |Å×ÀÌºí¿¡´Â ´ÙÀ½ Ä÷³ÀÌ Æ÷ÇԵ˴ϴÙ. |
|¿¹:
|¿¹ 1: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |±âº» ¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·Ä¿¡¼ ¸ðµç ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. |¸Þ½ÃÁö¿Í ¸ðµç ¸ÞŸµ¥ÀÌÅÍ°¡ Å×À̺í·Î ¸®Åϵ˴ϴÙ.
|SELECT * | FROM table (MQREADALLCLOB()) T
|¿¹ 2: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© MYSERVICE ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·ÄÀÇ Çìµå¿¡¼ ¸ðµç ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. |MSG¿Í CORRELID Ä÷³¸¸ ¸®Åϵ˴ϴÙ.
|SELECT T.MSG, T.CORRELID | FROM table (MQREADALLCLOB('MYSERVICE')) T
|¿¹ 3: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |±âº» ¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·ÄÀÇ Çìµå¸¦ ÀнÀ´Ï´Ù. |CORRELID°¡ '1234'ÀÎ ¸Þ½ÃÁö¿Í ¸ðµç Ä÷³ÀÌ ¸®Åϵ˴ϴÙ.
|SELECT * | FROM table (MQREADALLCLOB()) T | WHERE T.CORRELID = '1234'
|¿¹ 4: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |±âº» ¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â |óÀ½ 10°³ÀÇ ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. ¸ðµç Ä÷³ÀÌ ¸®Åϵ˴ϴÙ.
|SELECT * | FROM table (MQREADALLCLOB(10)) T
|>>-MQRECEIVEALLCLOB--(------------------------------------------> | |>--+----------------------------------------------------------+--> | '-receive-service--+-------------------------------------+-' | '-,--service-policy--+--------------+-' | '-,--correl-id-' | |>--+-----------------+--)-------------------------------------->< | '-+---+--num-rows-' | '-,-' | |
|½ºÅ°¸¶´Â DB2MQÀÔ´Ï´Ù.
|MQRECEIVEALLCLOB ÇÔ¼ö´Â service-policy ¼ºñ½º ±ÔÁ¤ Ç°ÁúÀ» »ç¿ëÇÏ¿© receive-service°¡ |ÁöÁ¤ÇÑ MQSeries À§Ä¡¿¡¼ ¸Þ½ÃÁö¿Í ¸Þ½ÃÁö ¸ÞŸµ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ Å×À̺íÀ» ¸®ÅÏÇÕ´Ï´Ù. |ÀÌ ÀÛ¾÷À» ¼öÇàÇϸé receive-service¿Í ¿¬°üµÈ ´ë±âÇà·Ä¿¡¼ |¸Þ½ÃÁö°¡ Á¦°ÅµË´Ï´Ù.
|correl-id¸¦ ÁöÁ¤Çϸé, ÀÏÄ¡ÇÏ´Â »ó°ü ID°¡ ÀÖ´Â ¸Þ½ÃÁö¸¸ |¸®Åϵ˴ϴÙ. correl-id°¡ ÁöÁ¤µÇ¾î ÀÖÁö ¾ÊÀ¸¸é ´ë±âÇà·Ä Çìµå¿¡ |ÀÖ´Â ¸Þ½ÃÁö°¡ ¸®Åϵ˴ϴÙ.
|num-rows°¡ ÁöÁ¤µÇ¾î ÀÖÀ¸¸é num-rows ¸Þ½ÃÁöÀÇ ÃÖ´ë Å©±â°¡ ¸®Åϵ˴ϴÙ. |num-rows°¡ ÁöÁ¤µÇ¾î ÀÖÁö ¾ÊÀ¸¸é »ç¿ë °¡´ÉÇÑ ¸ðµç ¸Þ½ÃÁö°¡ ¸®Åϵ˴ϴÙ. ¸®ÅÏµÈ |Å×ÀÌºí¿¡´Â ´ÙÀ½ Ä÷³ÀÌ Æ÷ÇԵ˴ϴÙ. |
|¿¹:
|¿¹ 1: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |±âº» ¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·Ä¿¡¼ ¸ðµç ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. |¸Þ½ÃÁö¿Í ¸ðµç ¸ÞŸµ¥ÀÌÅÍ°¡ Å×À̺í·Î ¸®Åϵ˴ϴÙ.
|SELECT * | FROM table (MQRECEIVEALLCLOB()) T
|¿¹ 2: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© MYSERVICE ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·ÄÀÇ Çìµå¿¡¼ ¸ðµç ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. |MSG¿Í CORRELID Ä÷³¸¸ ¸®Åϵ˴ϴÙ.
|SELECT T.MSG, T.CORRELID | FROM table (MQRECEIVEALLCLOB('MYSERVICE')) T
|¿¹ 3: ÀÌ ¿¹¿¡¼´Â "MYPOLOCY" ±ÔÁ¤À» »ç¿ëÇÏ¿© "MYSERVICE" ¼ºñ½º°¡ ÁöÁ¤ÇÑ |´ë±âÇà·Ä Çìµå¿¡¼ ¸ðµç ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. |CORRELID°¡ '1234'ÀÎ ¸Þ½ÃÁö¿Í MSG¿Í CORRELID Ä÷³¸¸ ¸®Åϵ˴ϴÙ.
|SELECT T.MSG, T.CORRELID | FROM table (MQRECEIVEALLCLOB('MYSERVICE','MYPOLICY','1234')) T |
|¿¹ 4: ÀÌ ¿¹¿¡¼´Â ±âº» ±ÔÁ¤(DB2.DEFAULT.POLICY)À» »ç¿ëÇÏ¿© |±âº» ¼ºñ½º(DB2.DEFAULT.SERVICE)°¡ ÁöÁ¤ÇÑ ´ë±âÇà·Ä Çìµå¿¡ ÀÖ´Â |óÀ½ 10°³ÀÇ ¸Þ½ÃÁö¸¦ ¼ö½ÅÇÕ´Ï´Ù. ¸ðµç Ä÷³ÀÌ ¸®Åϵ˴ϴÙ.
|SELECT * | FROM table (MQRECEIVEALLCLOB(10)) T
|MQSeries ÇÔ¼ö(DB2MQ ½ºÅ°¸¶¿¡ Á¤ÀǵǾî ÀÖÀ½)¿¡´Â ÇöÀç VARCHAR »Ó¸¸ ¾Æ´Ï¶ó CLOB µ¥ÀÌÅÍ¿Í |ÇÔ²² »ç¿ëÇÒ ¼ö ÀÖ´Â ÇÔ¼ö°¡ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù. ÀϺΠ»óȲ¿¡¼´Â »õ ÇÔ¼ö°¡ CLOB µ¥ÀÌÅÍ À¯ÇüÀ» |´Ù·ç°í ¶Ç ´Ù¸¥ ÀϺΠ»óȲ¿¡¼´Â ±âÁ¸ ÇÔ¼ö°¡ CLOB ¹× VARCHAR µ¥ÀÌÅÍ À¯ÇüÀ» ´Ù·ì´Ï´Ù. |¾î¶² °æ¿ìµç °£¿¡, CLOB ÇÔ¼ö ±¸¹®Àº VARCHAR ÇÔ¼ö ±¸¹®°ú ÀÏÄ¡ÇÕ´Ï´Ù. ´ÙÀ½ Å×ÀÌºí¿¡ |CLOB µ¥ÀÌÅÍ »ç¿ëÀ» Áö¿øÇÏ´Â ÇÔ¼ö¿Í ÀÌ¿¡ »óÀÀÇÏ´Â VARCHAR ÇÔ¼ö¸¦ ³ª¿ÇØ ³õ¾Ò½À´Ï´Ù.
|
|Ç¥ 18. CLOB µ¥ÀÌÅÍ À¯ÇüÀ» Áö¿øÇÏ´Â MQSeries ÇÔ¼ö
VARCHAR µ¥ÀÌÅÍ¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â ÇÔ¼ö | CLOB µ¥ÀÌÅÍ¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â ÇÔ¼ö |
---|---|
MQPUBLISH | MQPUBLISH |
MQREAD | MQREADCLOB |
MQRECEIVE | MQRECEIVECLOB |
MQSEND | MQSEND |
MQREADALL | MQREADALLCLOB |
MQRECEIVEALL | MQRECEIVEALLCLOB |
|MQSeries ÇÔ¼ö(DB2MQ ½ºÅ°¸¶¿¡ Á¤ÀǵǾî ÀÖÀ½) »ç¿ë¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â MQSeries¸¦ ÂüÁ¶ÇϽʽÿÀ.