You use an UPDATE statement to update data in an existing table.
In some environments, you cannot use SQL Assist to create UPDATE statements.
To create an UPDATE statement using SQL Assist:
Related tasks
Add search conditions to an SQL statement (WHERE or HAVING clause)
Add expressions
Create a SELECT statement
Create an INSERT statement
Create a DELETE statement
Edit an SQL statement
Check SQL syntax
Run an SQL statement