Previous Topic Next topic Print topic


STATICREADONLY

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.

Properties:

Default: NO
Previous Topic Next topic Print topic