1 Reply Latest reply on Apr 16, 2014 12:36 PM by Steven Hawkins

    Insert on duplicate key update not working

    teiiduser Newbie

      Hello,

      Does Teiid support for Oracle?

       

      INSERT INTO table (a,b,c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE c=c+1; 

      ?

      Trying to use this in the update query in transformation editor.

      It doesnt seem to work.

       

      Thank you!