Scalable Database Server, HiRDB Version 8 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.

Figure 2-21 shows an example of inserting a row on a row basis. Here, the values set in the embedded variable (:ZROW) are inserted on a row basis into the stock table.

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

[Figure]