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


Æ®¸®°Å ¼öÁØ

Æ®¸®°Å°¡ Ȱ¼ºÈ­µÇ¸é, ´ÙÀ½°ú °°Àº ¼öÁØ¿¡ µû¶ó ¼öÇàµË´Ï´Ù.

FOR EACH ROW
¿µÇâÀ» ¹ÞÀº Çà ÁýÇÕ¿¡¼­ Çà ¼ö¸¸Å­ÀÇ È½¼ö·Î ¼öÇàµË´Ï´Ù.

FOR EACH STATEMENT
Àüü Æ®¸®°Å À̺¥Æ®¿¡ ´ëÇÏ¿© ÇÑ ¹ø ¼öÇàµË´Ï´Ù.

¿µÇâÀ» ¹ÞÀº Çà ÁýÇÕÀÌ ºñ¾î ÀÖ´Â °æ¿ì, Áï WHEREÀý¿¡¼­ ¾î¶°ÇÑ Ç൵ Á¶°ÇÀ» ÃæÁ·½ÃŰÁö ¸øÇÑ °Ë»öµÈ UPDATE³ª DELETEÀÇ °æ¿ì, FOR EACH ROW Æ®¸®°Å´Â ¼öÇàµÇÁö ¾Ê½À´Ï´Ù. ±×·¯³ª FOR EACH STATEMENT Æ®¸®°Å´Â ÇÑ ¹ø ¼öÇàµË´Ï´Ù.

¿¹¸¦ µé¾î, Á÷¿ø ¼ö¸¦ °è¼Ó ¼¼°í ÀÖ´Â °ÍÀº FOR EACH ROW¸¦ »ç¿ëÇÏ¿© °¡´ÉÇÑ °ÍÀÔ´Ï´Ù.

    CREATE TRIGGER NEW_HIRED
      AFTER INSERT ON EMPLOYEE
      FOR EACH ROW MODE DB2SQL
      UPDATE COMPANY_STATS SET NBEMP = NBEMP + 1

FOR EACH STATEMENTÀÇ ¼öÁØÀ» »ç¿ëÇÏ¿© ÇÑ ¹øÀÇ °»½ÅÀ¸·Î µ¿ÀÏÇÑ ¿µÇâÀ» ¹ÌÄ¥ ¼ö ÀÖ½À´Ï´Ù.

    CREATE TRIGGER NEW_HIRED
      AFTER INSERT ON EMPLOYEE
      REFERENCING NEW_TABLE AS NEWEMPS
      FOR EACH STATEMENT MODE DB2SQL
      UPDATE COMPANY_STATS
      SET NBEMP = NBEMP + (SELECT COUNT(*) FROM NEWEMPS)
ÁÖ:FOR EACH STATEMENTÀÇ ¼öÁØÀº Æ®¸®°Å Ȱ¼ºÈ­ ½Ã°£¿¡¼­ ³íÀǵǴ BEFORE Æ®¸®°Å¿¡ ´ëÇÏ¿© Áö¿øµÇÁö ¾Ê½À´Ï´Ù.


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