17.00 - -501 Referenced cursor is not open - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Preprocessor2 for Embedded SQL
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1096-PP2

-501 Referenced cursor is not open

Possible Cause

The cursor referenced has been declared, but is not open.

Possible Solution

Open the cursor prior to cursor processing. If not explicitly closed (i.e., CLOSE request, COMMIT request, or an explicit ABORT/ROLLBACK request), verify that an implicit rollback did not occur. (An implicit rollback closes all open cursors associated with the current transaction.)