Instructs OpenESQL to check if singleton SELECTs return more than one row when executed. If this is the case, OpenESQL returns SQLCODE -811.
Syntax:
CHECKSINGLETON
NOCHECKSINGLETON
Properties:
| Default:
|
NOCHECKSINGLETON
|
Scope:
| Used at compile time:
|
No
|
| Behavior at run time:
|
Process
|
See
Scope - OpenESQL SQL Compiler Directive Options for more information.
Comments:
If CHECKSINGLETON is not specified, or NOCHECKSINGLETON is specified, and more than one row is returned, then OpenESQL returns SQLCODE -1.
CHECKSINGLETON is provided for DB2 compatibility.
