Instructs OpenESQL to determine if the cursor has been opened twice, and if so takes action accordingly.
Syntax:
CHECKDUPCURSOR
NOCHECKDUPCURSOR
Properties:
| Default:
|
NOCHECKDUPCURSOR
|
Scope:
| Used at compile time:
|
No
|
| Behavior at run time:
|
Process
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.
Comments:
If the cursor has been opened twice and the NOANSI92ENTRY directive has also been specified, CHECKDUPCURSOR returns SQLCODE -516 and sets SQLSTATE=24000.
If the cursor has been opened twice and NOANSI92ENTRY has not been specified, OpenESQL automatically closes the cursor and then re-opens it.
