| SQL adaptation guide For Genero db 3.6x, 3.8x / BDL programming | |
Informix® supports insert cursors. An "insert cursor" is a special BDL cursor declared with an INSERT statement instead of a SELECT statement. When this kind of cursor is open, you can use the PUT instruction to add rows and the FLUSH instruction to insert the records into the database.
For an Informix database with transactions, OPEN, PUT and FLUSH instructions must be executed within a transaction.
Genero db does not support insert cursors.
Insert cursors are emulated by the Genero db database driver.