Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009
    Posts
    2

    Unanswered: Creating trigger to transfre data in Syabase IQ

    Hi all,
    I want to transfer only updated data to another temp table. so i have created following trigger. but it's not working. so can some send me the working trigger with correct syntex. thanks a lot.

    create trigger Test_copy after insert on
    DBA.test_org
    referencing new as inserted
    for each row
    begin
    insert into DBA.test_back (ID, data) Select ID,data from inserted
    end

    Regards, krish

  2. #2
    Join Date
    Dec 2009
    Posts
    2
    Please help me solve this issue

Posting Permissions

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