SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-90
Considerations—CONTROL TABLE

The conditions listed in this table trigger flushing the INSERT/UPDATE buffer or
invalidating the READ buffers. If a problem such as a path error or disk full error
occurs during the flush, the disk process returns the error.
The buffer is flushed to the disk process, which puts the buffer in cache and writes
the data to disk when the table is closed or, for audited tables, when the
transaction commits. For nonaudited tables, the buffer is written to disk when the
FREE RESOURCES statement executes.

SQL does not buffer operations if any of the conditions described in the table
occur.
Condition
Flushes Buffer
for INSERTs
and UPDATEs
Invalidates
Buffer for
READs
A DML operation occurs on a table, interrupting a
sequential operation that has already begun.
XX
The buffer is full. X N.A.
A cursor is opened or closed on a table or view
with a sequential operation running.
XN.A.
A TMF transaction completes on an audited
table.
XX
A server replies to a requester. X X
A FREE RESOURCES statement is executed by
the current process.
XX
The table is closed. X X
The current TMF transaction is not the same as
the TMF transaction corresponding to the active
INSERT or UPDATE operations.
XX
Condition
Prevents
Buffering
for UPDATES
Prevents
Buffering
for INSERTS
A table is not a base table (operations for index
maintenance are not buffered).
XX
A table has at least one cursor defined by the
same process.
N.A. X
A relative or entry-sequenced table is indexed. N.A. X
An operation on a relative table does not occur at
end-of-file.
N.A. X
An operation on a relative or entry-sequenced
table includes the RETURNING clause with a
host variable.
N.A. X
A nonaudited table has one or more indexes, and
the operation involves variable length character
columns.
XN.A.