Creating an UPDATE statement
To create the example SQL UPDATE statement
UPDATE EMPLOYEE
SET CITY = :NEWCITY, JOBCODE = JOBCODE + 10
WHERE (STATE = 'NC') AND (STATUS = 'MOVE')
do the following:
1. On the SQL Statement - Settings window, do the following:
a. In the Connection alias field, select the connection specification for the database that contains the EMPLOYEE table.
b. In the Access set field, select the access set you want the UPDATE statement to be created in.
c. From the Query pull-down menu, select Create > UPDATE.
2. On the UPDATE Details window, do the following:
b. Select Apply.
Last modified date: 01/29/2015