▪The searched UPDATE statement, UDPATE table_name ... [WHEREsearch_condition], modifies the values of one or more columns in one or more rows specified with search_condition.
▪The positioned UPDATE statement, UPDATE table_name ... WHERE CURRENT OF cursor_name, updates the current row of the cursor. The name of the cursor is defined using ODBC API function named SQLSetCursorName.
table_name can be a table name or an alias.
Example of searched UPDATE
UPDATE TEST SET C = 0.44 WHERE ID = 5
Example of positioned UPDATE
UPDATE TEST SET C = 0.33 WHERE CURRENT OF MYCURSOR