Nonstop Database, HiRDB Version 9 UAP Development Guide
When retrieving data from a table with the FIX attribute, an entire row can be retrieved as a fixed-length record. In a sense, the entire row is manipulated as a single column. This is called retrieval on a row basis; ROW is specified in the selection clause of the SELECT statement.
Retrieval on a row basis reduces retrieving overhead for each column, so it enhances access performance.
The following figure shows, as an example of retrieval on a row basis, the procedure for using a cursor (CUR1) to retrieve the product name POLO SHIRT from the stock table and then setting it into an embedded variable (:XROW).
Figure 2-10 Example of retrieval on a row basis
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.