Determines whether or not static cursors are treated as READ ONLY.
Note:
This option is not supported by DRDA.
Syntax:
STATICREADONLY={NO | YES | INSENSITIVE}
Parameters:
NO
|
All static cursors take on the attributes generated based on the statement text and the setting of the LANGLEVEL option.
|
YES
|
Static cursors containing neither the FOR UPDATE nor the FOR READ ONLY clause are considered READ ONLY.
|
INSENSITIVE
|
Any static cursor that does not contain the FOR UPDATE clause is considered READ ONLY and INSENSITIVE.
|