Syntax
The UPDATE statement has the following format:
Interactive version:
UPDATE [schema.]table_name [corr_name]
[FROM from_source {, from_source}]
SET [corr_name.]column_name = expression{,
[corr_name.]column_name = expression}
[WHERE search_condition];
Embedded non-cursor version:
EXEC SQL [REPEATED] UPDATE [schema.]table_name [corr_name]{ ,
[FROM from_source {, from_source}]
SET [corr_name.]column_name = expression{,
[corr_name.]column_name = expression}
[WHERE search_condition];
Embedded cursor version:
EXEC SQL UPDATE [schema.]table_name
SET [corr_name.]column_name = expression{,
[corr_name.]column_name = expression}
WHERE CURRENT OF cursor_name;