Parameters—Update Statement
This statement has the following parameters:
tablename
Specifies the name of the database table that you want to update. This is a dynamic name.
corrname
Specifies the correlation name for the table. This is a dynamic name.
This parameter is used only in the non-cursor version.
columnname
Specifies the name of a particular column to be updated in the table. This is a dynamic name.
dbexpression
Specifies a database expression
searchcondition
Specifies a logical database expression of conditions that must be satisfied by all rows selected. You can use simple variables (preceded by colons) in a search condition wherever you can use a literal. Alternatively, you can place the entire search condition in a single varchar variable, and specify the search condition as the name of this variable (proceeded by a colon).
This parameter is only used in the non-cursor version.
cursor_variable
Specifies the reference variable that points to the CursorObject for which the statement is issued. Used only in the cursor version.
fromvariable
Specifies the entire from clause as a single varchar variable, preeded by a colon. This is a dynamic name.