The extended cursor name, when specified in an ALLOCATE CURSOR statement, identifies the cursor that is allocated to a group of result sets that are returned by a dynamic SELECT statement or a procedure. When specified in one of the following SQL statements, the extended cursor name permits operations on the cursor identified by it:
In addition, when directly specified in any of the following SQL statements, the value of an extended cursor name permits operations on the cursor identified by the extended cursor name:
extended-cursor-name :: = scope-option : embedded-variable |
Table 2-87 How to specify a scope option
Specification | Scope |
---|---|
GLOBAL | The extended statement name is enabled during the current SQL session (from the time HiRDB is connected until it is disconnected). |