Database Guide
To create the example SQL INSERT statement
INSERT INTO EMPLOYEE
(AGE, CITY, JOBCODE, NAME, STATE, STATUS)
VALUES (:AGE, :CITY, 34, :CUSTNAME, :STATE, NULL)
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
INSERT statement to be created in.
- From the Query pull-down menu, select Create
> INSERT.
- On the INSERT Details window, do the following:
- Specify the example INSERT statement.
- Select Apply.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]