Database Guide
To create the example SQL UPDATE statement
UPDATE EMPLOYEE
SET CITY = :NEWCITY, JOBCODE = JOBCODE + 10
WHERE (STATE = 'NC') AND (STATUS = 'MOVE')
do the following:
- On the SQL Statement - Settings window, do the following:
- In the Connection alias field, select the connection
specification for the database that contains the EMPLOYEE table.
- In the Access set field, select the access set you want the
UPDATE statement to be created in.
- From the Query pull-down menu, select Create
> UPDATE.
- On the UPDATE Details window, do the following:
- Specify the example UPDATE statement.
- Select Apply.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]