Insert...on duplicate key update in other databases(ParAccel) except MySql

Insert...on duplicate key update in MySql is not a sql standard. Can we treat this statement as atomic? Is there any equ开发者_如何学Goivalent statements in other databases especially ParAccel? If no,considering atomic or performance,how to design the statement by using sql92 sql99 or other standards?

---

The close equivalent in Standard SQL is MERGE, introduced in SQL-99 and altered slightly in SQL:2003.

MERGE is widely supported e.g. SQL Server 2008, Oracle 9, PostgreSQL, etc.