Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 18800 invoked from network); 9 Apr 2006 04:37:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 9 Apr 2006 04:37:42 -0000 Received: (qmail 48553 invoked by uid 500); 9 Apr 2006 04:37:41 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 48496 invoked by uid 500); 9 Apr 2006 04:37:40 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 48485 invoked by uid 99); 9 Apr 2006 04:37:40 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Apr 2006 21:37:40 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,MSGID_FROM_MTA_HEADER,SPF_HELO_PASS,SPF_PASS,UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of petergbowman@hotmail.com designates 65.54.224.47 as permitted sender) Received: from [65.54.224.47] (HELO hotmail.com) (65.54.224.47) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Apr 2006 21:37:39 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 8 Apr 2006 21:37:15 -0700 Message-ID: Received: from 65.54.224.200 by by105fd.bay105.hotmail.msn.com with HTTP; Sun, 09 Apr 2006 04:37:12 GMT X-Originating-IP: [61.8.120.33] X-Originating-Email: [petergbowman@hotmail.com] X-Sender: petergbowman@hotmail.com From: "Peter Bowman" To: derby-user@db.apache.org Subject: Derby Trigger Query Date: Sun, 09 Apr 2006 14:37:12 +1000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 09 Apr 2006 04:37:15.0870 (UTC) FILETIME=[47250FE0:01C65B8F] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi All, I have a trigger like: DROP TRIGGER RULE_10A; CREATE TRIGGER RULE_10A AFTER INSERT ON PLAN_NAME_TABLE REFERENCING NEW AS NEWROW FOR EACH ROW MODE DB2SQL INSERT INTO PLAN_NUTRIENT_TABLE (PLAN, NUTRIENT, NUTRIENT_TYPE, UNITS) VALUES (NEWROW.PLAN, 'Total Fat', 'Fat', 'g'); which inserts a new row into a table whenever a new row is inserted into another table, but is it possible to use a single trigger to insert several rows into the same table or do I have to write a separate trigger for each insert. Thanks in advance, Peter.