In embedded SQL, statements that retrieve data and statements that update data can both involve cursors.
The retrieval statements that involve cursors are:
DECLARE cursor_name CURSOR FOR ...
OPEN cursor_name
FETCH cursor_name INTO ...
CLOSE cursor_name
The update statements that involve cursors are:
UPDATE ... WHERE CURRENT OF cursor_name
DELETE ... WHERE CURRENT OF cursor_name
To use the UPDATE ... WHERE CURRENT OF or DELETE
... WHERE CURRENT OF statements, you must set
the CursorUpdate DBParm parameter to 1 before declaring the cursor.
(By default, CursorUpdate is set to 0.)
For example:
SQLCA.DBParm = "CursorUpdate = 1"
You can set the CursorUpdate parameter at any time before or after connecting to the database. You can also change its setting at any time.
