Syntax of UPDATE statements

Informix^® allows a specific syntax for UPDATE statements:

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

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