Database Guide
To specify the example SQL INSERT statement
INSERT INTO EMPLOYEE
(AGE, CITY, JOBCODE, NAME, STATE, STATUS)
VALUES (:AGE, :CITY, 34, :CUSTNAME, :STATE, NULL)
do the following:
- In the Query name field, type a name for the INSERT
statement.
- In the Description field, type a description for the INSERT
statement.
- In the Table/view field, select EMPLOYEE from the
drop-down list.
- From the Columns pop-up menu, select Select
all.
- In the INSERT columns list, select NAME.
- In the Column value field, type CUSTNAME.
- From the Column value pull-down menu, select Host variable
:x.
- In the INSERT columns list, select JOBCODE.
- In the Column value field, type 34.
- In the INSERT columns list, select STATUS.
- From the Column value pull-down menu, select
NULL.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]