base.SqlHandle.flush

Flushes the rows from the insert cursor buffer.

Syntax

flush()

Usage

With an insert cursor, call the flush() method to force the buffered rows to the database server.

The SQL statement must have been opened with a open() call.

As with standard Genero SQL instructions, SQL errors can be trapped with WHENEVER ERROR or TRY / CATCH blocks and by testing SQLCA.SQLCODE.

Example

CALL sh.flush()