Results 1 to 3 of 3

Thread: Trigger.

  1. #1
    Join Date
    Feb 2002
    Posts
    96

    Question Unanswered: Trigger.

    Hi,

    I need to write a trigger for delete operation. But it is not capturing the required details.

    Whenever i perform delete operation on tableA, i need to capture col1 of tableA in AUDIT_table.

    My trigger :
    CREATE TRIGGER AUDIT_T1
    AFTER DELETE ON tableA
    REFERENCING OLD AS N_ROW
    FOR EACH ROW MODE DB2SQL
    BEGIN ATOMIC INSERT INTO AUDIT_table VALUES
    ((SELECT col1 FROM tableA WHERE N_ROW.col1 = tableA.col1)); END;

    I appreciate your help on this. Thank you.

    Regards
    Prakash

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Trigger.

    See if this works

    CREATE TRIGGER AUDIT_T1
    AFTER DELETE ON tableA
    REFERENCING OLD AS N_ROW
    FOR EACH ROW MODE DB2SQL
    INSERT INTO AUDIT_table(col1) VALUES(N_ROW.col1)

    Cheers
    Sathyaram

    Originally posted by cgprakash
    Hi,

    I need to write a trigger for delete operation. But it is not capturing the required details.

    Whenever i perform delete operation on tableA, i need to capture col1 of tableA in AUDIT_table.

    My trigger :
    CREATE TRIGGER AUDIT_T1
    AFTER DELETE ON tableA
    REFERENCING OLD AS N_ROW
    FOR EACH ROW MODE DB2SQL
    BEGIN ATOMIC INSERT INTO AUDIT_table VALUES
    ((SELECT col1 FROM tableA WHERE N_ROW.col1 = tableA.col1)); END;

    I appreciate your help on this. Thank you.

    Regards
    Prakash
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2002
    Posts
    96

    Re: Trigger.

    Thanks alot Sathyaram.

    Regards
    Prakash

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •