The SQL statements are first prepared with the EXEC SQL PREPARE statement.

The cursor_name specification is a cursor name that must be given. It can be any unique cursor name inside the transaction. If the procedure is not a complete transaction, other open cursors outside the procedure may have conflicting cursor names.