4. Accessing a DBMS Using SQL : SQL Syntax : Declare Statement, Open Cursor Statement
Share this page                  
Declare Statement, Open Cursor Statement
The declare cursor statement is not supported; the information associated with declare cursor is provided when the cursor is opened.
This statement has the following syntax in OpenAPI:
statement_name | select_statement [for readonly]
The open cursor syntax consists of the statement name or select statement text which in embedded SQL would be provided in the declare cursor statement, along with an optional for readonly clause. Do not include a using clause with the open cursor query. The application can provide a cursor name as a parameter to the open cursor query. If the application does not provide a cursor name, a default name of the form IIAPICURSORn (where n is an integer) is used.