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

The following figure shows, as an example of inserting rows on a column basis, the procedure for inserting the values set in embedded variables (:ZPCODE to :ZSQUANTITY) into columns in the stock table.

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