Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
PUT statementUse the PUT statement to store a row in an insert buffer for later insertion into the database.
Writing Buffered Rows

Writing Buffered Rows

To open an Insert cursor, the OPEN statement creates an insert buffer. The PUT statement puts a row into this insert buffer. The buffered rows are inserted into the database table as a block only when necessary; this process is called flushing the buffer. The buffer is flushed after any of the following events:

Buffer is too full to hold the new row at the start of a PUT statement.
A FLUSH statement executes.
A CLOSE statement closes the cursor.
An OPEN statement specifies an already open cursor, closing it before reopening it. (This implicit CLOSE statement flushes the buffer.)
A COMMIT WORK statement executes.
Buffer contains BYTE or TEXT data (flushed after a single PUT statement).

If the program terminates without closing an Insert cursor, the buffer remains unflushed. Rows that were inserted into the buffer since the last flush are lost. Do not rely on the end of the program to close the cursor and flush the buffer.