Syntax of UPDATE statements

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.*

Solution

Static UPDATE statements using this syntax are converted by the compiler to the standard form:

UPDATE table SET column=value [,...]