Database Guide


Creating an INSERT statement

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:

  1. On the SQL Statement - Settings window, do the following:
    1. In the Connection alias field, select the connection specification for the database that contains the EMPLOYEE table.
    2. In the Access set field, select the access set you want the INSERT statement to be created in.
    3. From the Query pull-down menu, select Create > INSERT.
  2. On the INSERT Details window, do the following:
    1. Specify the example INSERT statement.
    2. Select Apply.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]