Insert on duplicate key update not working

teiiduser Apr 16, 2014 12:04 PM

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!

1. Re: Insert on duplicate key update not working

shawkins Apr 16, 2014 12:36 PM (in response to teiiduser)

We do not have direct support for that syntax. The closest that we have is a simple merge command - DML Commands - Teiid 8.7 (draft) - Project Documentation Editor

Another option is to use a direct query procedure to issue the sql directly to the source.
1 of 1 people found this helpful
Actions