To insert a single row by directly specifying values in each column, use the INSERT statement.

Figure 2-20 shows an example of insertion on a column basis. Here, values set in embedded variables (:ZPCODE to :ZSQUANTITY) are inserted in the columns of the stock table.

Figure 2-20 Example of row insertion on a column basis