Nonstop Database, HiRDB Version 9 UAP Development Guide

[Contents][Index][Back][Next]

2.6.2 Inserting rows on a row basis (to a table with the FIX attribute)

When rows are inserted into a table with the FIX attribute, an entire row can be inserted as a fixed-length record. To insert a row on a row basis, ROW must be specified in the INSERT statement.

Rows can be inserted on a row basis only into a base table.

The following figure shows, as an example of inserting rows on a row basis, the procedure for inserting into the stock table the values set in an embedded variable (:ZROW).

Figure 2-21 Example of row insertion on a row basis

[Figure]