PUT (insert cursor)

Adds a new row to the insert cursor buffer.

Syntax

PUT cid FROM pvar [,...]
  1. cid is the identifier of the insert cursor.
  2. pvar is a variable containing an input value for the new row.

Usage

The PUT instruction adds a row to the insert cursor buffer.

If the insert cursor was not declared WITH HOLD option, the PUT instruction generates an SQL error if there is no current transaction started.

If the insert buffer has no room for the new row when the statement executes, the buffered rows are written to the database in a block, and the buffer is emptied. As a result, some PUT statement executions cause rows to be written to the database, and some do not.