8. OpenSQL Statements : Update : Syntax
 
Share this page                  
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;