| SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data manipulation | |
Informix® allows a specific syntax for UPDATE statements:
UPDATE table SET ( col-list ) = ( val-list )
or
UPDATE table SET table.* = myrecord.*
UPDATE table SET * = myrecord.*
Static UPDATE statements using this syntax are converted by the compiler to the standard form:
UPDATE table SET column = value [,...]