Æ®¸®°Å°¡ Ȱ¼ºÈµÇ¸é, ´ÙÀ½°ú °°Àº ¼öÁØ¿¡ µû¶ó ¼öÇàµË´Ï´Ù.
¿µÇâÀ» ¹ÞÀº Çà ÁýÇÕÀÌ ºñ¾î ÀÖ´Â °æ¿ì, Áï 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 Æ®¸®°Å¿¡ ´ëÇÏ¿© Áö¿øµÇÁö ¾Ê½À´Ï´Ù. |