Link to this page
Print this page
Parent topic
:
SQL support
SQL support
SQL insert cursors
Explains how to insert a log of rows into a table efficiently.
Understanding SQL insert cursors
DECLARE (insert cursor)
The
DECLARE
with an
INSERT
instruction defines an insert cursor.
OPEN (insert cursor)
Initializes an insert cursor.
PUT (insert cursor)
Adds a new row to the insert cursor buffer.
FLUSH (insert cursor)
Flushes the buffer of an insert cursor.
CLOSE (insert cursor)
Flushes and closes an insert cursor.
FREE (insert cursor)
Releases resources allocated for an insert cursor.
Examples