DB2 Version 9.7 for Linux, UNIX, and Windows

IS_OPEN procedure - Check if a cursor is open

The IS_OPEN function provides the capability to test if the given cursor is open.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_SQL.IS_OPEN--(--c--,--ret--)---------------------------><

Parameters

c
An input argument of type INTEGER that specifies the cursor ID of the cursor to be tested.
ret
An output argument of type BOOLEAN that indicates if the specified file is open (TRUE) or closed (FALSE).

Authorization

EXECUTE privilege on the DBMS_SQL module.

Usage notes

This procedure can be invoked using function invocation syntax in a PL/SQL assignment statement.

Parent topic: DBMS_SQL module