SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-176
Cursor Position
Cursor Position
Cursor position is similar to record position in a sequential file. Operations cause the
cursor to be positioned:
Your SELECT determines the order in which rows are returned through a cursor. To
specify the order, include an ORDER BY clause; otherwise, the order is undefined.
Cursor Stability
Cursor stability guarantees that the row at the current position of the cursor cannot be
modified by another transaction. SQL does not guarantee cursor stability unless you
define the cursor with the FOR UPDATE clause or you specify the REPEATABLE
access option.
A cursor lacks stability if it points to a copy of the data and the data is concurrently
available to other applications. Unless you specify the FOR UPDATE clause, this can
happen when the SELECT that defines the cursor requires any of these operations:

Ordering the rows by a column

Removing duplicate rows

Performing other operations requiring that the table be copied into an interim result
table before use by your program
C89
The c89 command invokes components of the C compilation system from the OSS
environment. You can use it to perform any phase of a C compilation, including
compiling, binding, accelerating, and SQL-compiling (compiling C programs that
contain embedded SQL statements).
For information about c89, see the C/C++ Programmer's Guide or the SQL/MP
Programming Manual for C.
OPEN Before the first row
FETCH On the retrieved row (the current position)
DELETE Between rows
UPDATE No change (the current position)
CLOSE No position