Results 1 to 3 of 3

Thread: Update row

  1. #1
    Join Date
    Nov 2009
    Posts
    5

    Unanswered: Update row

    Hello!

    I would like to create insert-trigger on table A1, that will update the value in table A2. The value is intermed. I should update only 1 cell in A2, not column..
    How can I do it?

    for example,


    CREATE TRIGGER My_INSERT
    AFTER INSERT ON A1

    FOR EACH ROW MODE DB2SQL

    BEGIN ATOMIC
    ....

    SET ???? = intermed;
    END@

    Thanks!

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    What is "intermed"?
    From where it came? A column of table A1?

    Does "only 1 cell" mean "only 1 row"?
    If so, you should specify WHERE clause in your update statement in your trigger.

  3. #3
    Join Date
    Nov 2009
    Posts
    5
    Thanks for answer!

Posting Permissions

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