Rowset fetches and inserts

For rowset-positioned cursors, when the cursor is opened for rowset processing, the answer set is returned in a single query block. The query block contains exactly the number of rows that are specified for the rowset.

Because a rowset is returned in a single query block, the size of a rowset is limited to 10 MB. This rowset size minimizes the impact to the network when retrieving a large rowset with a single fetch operation.

Rowset-positioned cursors also allow multiple-row inserts. The INSERT statement, in addition to the FOR n ROWS clause, inserts multiple rows into a table or view, by using values that host-variable arrays provide. With multiple-row inserts, rather than INSERT statements being sent for each individual insert, all insert data is sent in a single network message.