-517   CURSOR cursor-name CANNOT BE USED BECAUSE ITS STATEMENT NAME DOES NOT IDENTIFY A PREPARED SELECT STATEMENT

Explanation

The cursor 'cursor-name' could not be used as specified because the prepared statement named in the declaration for the cursor was not a SELECT statement.

System action

The statement cannot be processed.

Programmer response

Verify that the statement-name is specified correctly in the PREPARE statement and the DECLARE CURSOR statement for cursor 'cursor-name'. Alternatively, correct the application program logic to ensure that only prepared SELECT statements are used in association with cursor declarations.

SQLSTATE

07005