µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¿¡ »õ ±¸¼º Ãß°¡

»õ ±¸¼ºÀ» µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¿¡ Ãß°¡ÇÏ·Á¸é ´ÙÀ½ ±¸¹®À» ÂüÁ¶ÇϽʽÿÀ. ¿¹¸¦ µé¾î, ¿ÀºêÁ§Æ® o1Àº col1, col2, lastupdate, col3 ¿­À» Æ÷ÇÔÇÏ´Â Å×À̺í R1À¸·Î ±¸¼ºµË´Ï´Ù. lastupdate°¡ nÀÏ ÀüÀ̰í col1ºÎÅÍ 10ÀÚ±îÁöÀÇ ¸ðµç ¿ÀºêÁ§Æ®¸¦ »èÁ¦Çϵµ·Ï µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¸¦ ±¸¼ºÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. DB2 ¸í·É ÇÁ·ÒÇÁÆ®¸¦ ¿©½Ê½Ã¿À.
  2. ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
    db2 insert into cleanconf (objectname, type, statement, namearg, sequence, daysarg) values ('o1', 'obsolete', 'delete from r1 where col1 > 10 and (days(CURRENT TIMESTAMP) - days(lastupdate)) > ?', 'no', 1, 'yes')
  1. ´ÙÀ½ SQL¹®À» ½ÇÇàÇϽʽÿÀ.
    insert into cleanconf (objectname, type, statement, namearg, sequence, daysarg) values ('o1', 'obsolete', 'delete from r1 where col1 > 10 and (days(CURRENT TIMESTAMP) - days(lastupdate)) > ?', 'no', 1, 'yes')

  1. SQLPlus ¸í·ÉâÀ» ¿©½Ê½Ã¿À.
  2. ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
    insert into cleanconf (objectname, type, statement, namearg, sequence, daysarg) values ('o1', 'obsolete', 'delete from r1 where col1 > 10 and (sysdate - lastupdate) > ?', 'no', 1, 'yes')

¿©±â¼­?´Â ´ÙÀ½ ¸í·ÉÇà¿¡¼­ -days ¸Å°³º¯¼ö·Î ¹Ù²ò´Ï´Ù. 'no'´Â ¸í·É¹®¿¡¼­ name ¸Å°³º¯¼ö°¡ »ç¿ëµÇÁö ¾ÊÀ½À» ³ªÅ¸³À´Ï´Ù. 'yes'´Â ¸í·É¹®¿¡¼­ -days ¸Å°³º¯¼ö°¡ »ç¿ëµÊÀ» ³ªÅ¸³À´Ï´Ù. 'obsolete'´Â ¿ÀºêÁ§Æ® o1ÀÇ Á¤¸® À¯ÇüÀ» ¼³¸íÇÕ´Ï´Ù. ´Ù¸¥ ´Ü¾î¸¦ »ç¿ëÇÒ ¼öµµ ÀÖÁö¸¸, µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼ ¸í·ÉÀ» ½ÇÇàÇÒ ¶§ -type Àμö¿¡ ÀÖ´Â ´Ü¾î¿Í °°Àº ´Ü¾î¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.

¿¹

µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼ ¸í·ÉÀ» ½ÇÇàÇÏ¿© »õ Å×ÀÌºí¿¡¼­ 2ÀÏÀÌ Áö³­ ·¹Äڵ带 »èÁ¦ÇÏ·Á¸é ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.

ÁÖ: Oracle dbname ¸Å°³º¯¼ö·Î´Â host:port:sid ¸¦ »ç¿ëÇϽʽÿÀ(¿¹: myhost:1521:mydb).

 °ü·Ã °³³ä

°ü·Ã ŽºÅ©

°ü·ÃµÈ ÂüÁ¶

IBM copyright