Relational Data Framework Reference › SQL Statements › ops--OPEN Statement—Initiate Cursor Operation

ops--OPEN Statement—Initiate Cursor Operation

Issue an OPEN statement to initiate a cursor operation. When the OPEN statement is issued, the SELECT criteria for the cursor operation (specified with the DECLARE CURSOR statement) is immediately executed.

Note: The SQL command that executes the OPEN statement must be issued from an AOF rule, an OPS/REXX program, a TSO/E REXX program, or a TSO CLIST. You cannot invoke SQL commands that perform cursor operations from a TSO terminal.

Use this syntax in an AOF rule or an OPS/REXX program:

ADDRESS SQL "OPEN keywords"
{cursorname}
[SYSTEM(ALL|EXT|sysnames)]
[SYSWAIT(seconds)]
[OUTPUT|NOOUTPUT]
[SYSPLEX]

Use this syntax to invoke the statement from a TSO/E REXX program or a TSO CLIST:

OPSQL OPEN {cursorname}

You may specify these operands for the OPEN statement:

cursorname

Defines the name of the cursor you are initiating (previously defined using the DECLARE CURSOR statement).

SYSTEM

(Optional) Performs cross-system SQL operations. Specify one of these values:

ALL

Routes the SQL command to all active MSF-defined systems, including the local system.

EXT

Routes the SQL command to all remote, active MSF-defined systems.

sysnames

Routes the SQL command to the specified systems. You may specify from one to eight system names.

For more information, see the chapter “Using the Relational Data Framework” in the User Guide.

SYSWAIT

(Optional). Defines the number of seconds the SQL processor waits for output from a remote system. You may specify a value between 1 and 300 seconds.

Do not specify a value for SYSWAIT if you specify the SYSTEM(ALL), SYSTEM(EXT), or NOOUTPUT keywords.

OUTPUT or NOOUTPUT

(Optional) Indicates whether the command returns output to the external data queue. Specify OUTPUT to have output returned; otherwise, specify NOOUTPUT.

NOOUTPUT is implied when:

• The ADDRESS SQL command is issued in an AOF rule.
• You specify more than one system name as the value of the SYSTEM(sysnames) keyword.
• You specify SYSTEM(ALL) or SYSTEM(EXT).

SYSPLEX

(Optional) Reduces the scope of the SYSTEM(ALL|EXT) operand to MSF connected systems that belong to the same z/OS sysplex as the command issuer. The keyword has no effect on a list of explicit system names.

Example: Initiate a cursor operation named STATDOWN

To initiate the cursor operation named STATDOWN, issue this command from an OPS/REXX program:

ADDRESS SQL
  "OPEN STATDOWN"