Syntax of UPDATE statements

Informix® allows a specific syntax for UPDATE statements:

UPDATE table SET ( col-list ) = ( val-list )

Or

UPDATE table SET table.* = codeph.*

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 [,...]