The Column value field shows the value a column is set to in the VALUES clause. The value is for the column you have selected in the INSERT columns list.

The initial value set for each column is a host variable with the same name as the column.

Use this field to specify a new value for a column in the INSERT columns list. The value can be a literal, host variable, or NULL.

You can use the Column value pull-down menu to specify NULL for the column value.

To apply a unary operator to the column value you have specified, from the Column value pull-down menu, select the unary operator you want to apply.

For the INSERT statement to be valid, you must specify a value for each column in the VALUES clause.

The data type of the column you have selected in the INSERT columns list is displayed directly below the Column value field.

If there are no columns in the INSERT columns list or one is not selected, Column value is unavailable.