SQL support / SQL insert cursors |
Adds a new row to the insert cursor buffer.
PUT cid FROM pvar [,...]
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.