Specifies that the cursor object has been closed or has never had an open statement executed on it. All newly created cursor objects have this state.

Specifies that the cursor object has been opened (with the open statement) but no rows have been fetched

Specifies the state of a cursor object after a successful fetch. The cursor retains this state after a successful cursor update, but does not indicate that a new row has been fetched.

Specifies the state of a cursor object after a successful cursor delete statement

Specifies the state of a cursor object after a fetch statement that found no more rows to fetch (that is, all rows had been previously fetched)

Specifies the state of a cursor after it has been opened implicitly by execution of an execute procedure ... into:cursobj statement, but before any rows have been fetched.

When executing a cursor object against an Ingres database, because the DBMS never returns rows, the first fetch against a cursor in the CS_OPEN_CACHED state results in the state proceeding to CS_NO_MORE_ROWS.