DB2 Universal Database(TM)(UDB) ¹öÀü 8.2 FixPak 1(¹öÀü 8.1 FixPak 8°ú µ¿ÀÏ)ºÎÅÍ ¸í·ÉÇà 󸮱â(CLP) ¶Ç´Â ¸í·É ÆíÁý±â¿¡¼ ½ÇÇàÇÒ ½ºÅ©¸³Æ® ³»ÀÇ ¸í·É¹® Á¾·á ¹®ÀÚ¸¦ ¼öÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¼öÁ¤Àº ÇöÀç OS/390(R)¿ë DB2(R) UDB¿¡¼ »ç¿ë °¡´ÉÇÑ ¸Þ¼Òµå¿Í À¯»çÇÕ´Ï´Ù. ´ÙÀ½ ¿¹´Â °¢ ¸í·É¹® µÚÀÇ Á¾·á ¹®ÀÚ¸¦ º¯°æÇÏ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù.
connect to gilroy user newton using password; select * from newton.department; --#SET TERMINATOR : select * from newton.employee: --#SET TERMINATOR @ select * from newton.department@ --#SET TERMINATOR ; select * from newton.department; --#SET TERMINATOR & terminate&
Á¾·á ¹®ÀÚ º¯°æ ±â´ÉÀº ½ºÅ©¸³Æ®¿¡ º¹ÇÕ ¸í·É¹®ÀÌ ÀÖ´Â °æ¿ì¿¡ Áß¿äÇÕ´Ï´Ù. ´ÙÀ½ ¿¹¿¡¼, DB2 UDB´Â º¹ÇÕ CREATE TRIGGER¹®¿¡¼ ¹ß°ßÇϴ ù ¹ø° ¼¼¹ÌÄÝ·Ð(;)ÀÌ Àüü CREATE TRIGGER¹®¿¡ ´ëÇÑ Á¾·á ¹®ÀÚ¶ó°í °¡Á¤ÇÕ´Ï´Ù. ±×·¯³ª ½ÇÁ¦·Î ±×·¸Áö ¾Ê½À´Ï´Ù. ÀÌ ¹®ÀÚ´Â º¹ÇÕ CREATE TRIGGER¹® ³»¿¡ ÀÖ´Â ¸í·É¹® Áß Çϳª¿¡ ´ëÇÑ Á¾·á ¹®ÀÚ·Î »ç¿ëµË´Ï´Ù.
CONNECT TO SAMPLE; DROP TRIGGER newton.NWTTRIGGER; CREATE TRIGGER newton.NWTTRIGGER AFTER DELETE ON newton.NWTTABLE FOR EACH ROW MODE DB2SQL BEGIN ATOMIC insert into newton.nwttable values(0,'0'); insert into newton.nwttable values( -1, '-1'); END; CONNECT RESET; TERMINATE;
´ÙÀ½ ¿¹´Â ¿øÇÏ´Â °á°ú¸¦ ¾ò±â À§ÇØ ½ºÅ©¸³Æ® ³»ÀÇ ¸í·É¹® Á¾·á ¹®ÀÚ¸¦ ¼öÁ¤ÇÏ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù.
CONNECT TO SAMPLE; DROP TRIGGER newton.NWTTRIGGER; --#SET TERMINATOR @ CREATE TRIGGER newton.NWTTRIGGER AFTER DELETE ON newton.NWTTABLE FOR EACH ROW MODE DB2SQL BEGIN ATOMIC insert into newton.nwttable values(0,'0'); insert into newton.nwttable values( -1, '-1'); END@ --#SET TERMINATOR ; CONNECT RESET;
½ºÅ©¸³Æ®¸¦ OS/390¿ë DB2¿¡¼ ·ÎÄ÷Π½ÇÇàÇÒ ÇÊ¿ä°¡ ¾ø°Å³ª, DB2 UDB ½ºÅ©¸³Æ®¸¦ OS/390¿¡ ¿¬°áÇÏÁö ¾Ê´Â °æ¿ì, --#SET TERMINATOR¸¦ »ç¿ëÇÏ¿© ¸í·É¹® Á¾·á ¹®ÀÚ¸¦ ¼öÁ¤ÇÏ´Â °ÍÀº ¹Ù¶÷Á÷ÇÏÁö ¾Ê½À´Ï´Ù. ´ë½Å, ±âÁ¸ÀÇ -tdX ¶Ç´Â ;-- ¿É¼ÇÀ» »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.
CLP ¸í·ÉÀ» »ç¿ëÇÏ¿© ½ºÅ©¸³Æ®¸¦ È£ÃâÇÒ ¶§, -tdX ¿É¼ÇÀ» »ç¿ëÇÏ¿© Á¾·á ¹®ÀÚ¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. 'X'´Â ¸í·É¹® Á¾·á ¹®ÀÚ·Î »ç¿ëµÇ´Â ¹®ÀÚ¸¦ ³ªÅ¸³À´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½ ¸í·É°ú °°½À´Ï´Ù.
db2 -tvf test.txt -td&
&´Â test.txt ÆÄÀÏ¿¡¼ ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÒ ¶§ ¸í·É¹® Á¾·á ¹®ÀÚ·Î »ç¿ëµË´Ï´Ù. ÇØ´ç ½ºÅ©¸³Æ®¿¡ º¹ÇÕ CREATE TRIGGER¹®ÀÌ Æ÷ÇÔµÈ °æ¿ì, ´ÙÀ½°ú °°ÀÌ ÀÛ¼ºµË´Ï´Ù.
CONNECT TO SAMPLE& DROP TRIGGER newton.NWTTRIGGER& CREATE TRIGGER newton.NWTTRIGGER AFTER DELETE ON newton.NWTTABLE FOR EACH ROW MODE DB2SQL BEGIN ATOMIC insert into newton.nwttable values(0,'0'); insert into newton.nwttable values( -1, '-1'); END& CONNECT RESET& TERMINATE&
º¹ÇÕ CREATE TRIGGER¹®ÀÌ Æ÷ÇÔµÈ ½ºÅ©¸³Æ®µµ ´ÙÀ½°ú °°ÀÌ ;-- ¿É¼ÇÀ» »ç¿ëÇÏ¿© ÀçÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
CONNECT TO SAMPLE; DROP TRIGGER newton.NWTTRIGGER; CREATE TRIGGER newton.NWTTRIGGER AFTER DELETE ON newton.NWTTABLE FOR EACH ROW MODE DB2SQL BEGIN ATOMIC insert into newton.nwttable values(0,'0');-- insert into newton.nwttable values( -1, '-1');-- END; CONNECT RESET; TERMINATE;
Á¦¾î ¼¾ÅÍÀÇ ¼¼ºÎ»çÇ× ºÐÇÒâÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ Á¤º¸¸¦ º¼ ¼ö ÀÖ½À´Ï´Ù. ¿ÀºêÁ§Æ® Æ®¸® ¶Ç´Â ÄÁÅÙÃ÷ ¿µ¿ª¿¡¼ µ¥ÀÌÅͺ£À̽º¸¦ ¼±ÅÃÇϸé ÇØ´ç »óÅ ¿ä¾àÀÌ Ç¥½ÃµË´Ï´Ù. ƯÁ¤ »óȲ¿¡¼ µ¥ÀÌÅͺ£À̽º Á¤º¸°¡ »ç¿ë ºÒ°¡´ÉÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ »ç¿ë ºÒ°¡´É¿¡ ´ëÇÑ ÀϺΠÀÌÀ¯°¡ ´ÙÀ½ Ç¥¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º »óÅ ¿ä¼Ò | »ç¿ë ºÒ°¡´ÉÇÑ »óÅÂÀÇ ÀÌÀ¯ |
---|---|
¸¶Áö¸· ¹é¾÷ |
|
Å©±â |
|
¿ë·® |
|
¼º´É »óÅ |
|
À¯Áöº¸¼ö |
|
À̺¥Æ® ¸ð´ÏÅÍ ÀÛ¼º â¿¡¼ ½ÇÇàµÇ´Â Ãâ·Â ¿É¼Ç ´ëÈ »óÀÚ¿¡ »ý¼º ´ÜÃß°¡ Ãß°¡µÇ¾ú½À´Ï´Ù. »ý¼º ´ÜÃ߸¦ ´©¸£¸é µðÆúÆ®°ªÀÎ Å×À̺í Ãâ·Â¿¡ ±â·Ï ¿É¼ÇÀÌ »ý¼ºµË´Ï´Ù. ÀÌ Ãâ·ÂÀº db2evtbl ¸í·ÉÀÌ »ý¼ºÇÏ´Â ±¸¹®°ú °°½À´Ï´Ù.
»ý¼ºµÈ ¿É¼ÇÀº »ç¿ëÀÚ¿¡°Ô À̺¥Æ® ¸ð´ÏÅ͸¦ ÀÛ¼ºÇÒ ¶§ Æ÷Ç﵃ µ¥ÀÌÅÍ ¿ä¼Ò¿Í Å×À̺íÀ» Ç¥½ÃÇÕ´Ï´Ù. »ç¿ëÀÚ´Â ÇÊ¿ä¿¡ ÀûÇÕÇÏ°Ô ¸í·ÉÀ» ¼öÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
»ý¼ºµÇ´Â ±¸¹®Àº À̺¥Æ® ¸ð´ÏÅÍ ÀÛ¼º â¿¡¼ ÁöÁ¤ÇÑ À̺¥Æ® ¸ð´ÏÅÍ À̸§°ú À̺¥Æ® À¯ÇüÀ» ±âÃÊ·Î ÇÕ´Ï´Ù. Ãâ·Â ¿É¼Ç ±¸¹®À» »ý¼ºÇϱâ Àü¿¡ À̺¥Æ® ¸ð´ÏÅÍ À̸§°ú À̺¥Æ® À¯ÇüÀ» ÁöÁ¤ÇϽʽÿÀ.
Ãâ·Â ¿É¼Ç »ý¼º ÈÄ À̺¥Æ® ¸ð´ÏÅÍ À̸§À̳ª À̺¥Æ® À¯ÇüÀÌ º¯°æµÇ¸é, »ç¿ëÀÚ¿¡°Ô À̺¥Æ® ¸ð´ÏÅ͸¦ ÀÛ¼ºÇϱâ Àü¿¡ Ãâ·Â ¿É¼ÇÀ» ´Ù½Ã »ý¼ºÇÒ °ÍÀ» ¾Ë¸®´Â ¸Þ½ÃÁö°¡ Ç¥½ÃµË´Ï´Ù. Ãâ·Â ¿É¼ÇÀÌ ´Ù½Ã »ý¼ºµÇÁö ¾ÊÀ¸¸é, ÀÌÀü¿¡ ÁöÁ¤ÇÑ À̺¥Æ® ¸ð´ÏÅÍ À̸§À» ±âÃÊ·Î À̺¥Æ® Å×À̺íÀÌ »ý¼ºµË´Ï´Ù.
[ ÆäÀÌÁöÀÇ ¸Ç À§ |ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ ]