SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-5
CURSOR_DELETE Operator
The example of the CALL operator is based on:
create procedure mx_proc2(in a int, in b int, inout c int)
external name 'myClass.myMethod'
external path '/usr/spj/classes'
language java parameter style java no sql;
input_values: cast(1), cast(2), cast(?c)
parameter_modes: I I N
routine_name: CAT.SCH.MX_PROC2
routine_label: \BINGO.$DATA10.ZSDL2M3C.NCT8VS00
sql_access_mode: NO SQL
external_name: myMethod
external_path: /usr/spj/classes
external_file: myClass
signature: (II[I)V
language: Java
runtime_options: OFF
runtime_option_delimiters: ' '
CURSOR_DELETE Operator
DAM Unique Group
The CURSOR_DELETE operator describes a portion of an execution plan that works
on one row only. The CURSOR_DELETE operation is performed by first retrieving
rows from the table and then deleting each row that is required. This operation differs
from SUBSET_DELETE, in which the read and delete are performed in a combined
operation.
The CURSOR_DELETE operator has no child nodes. The description field for this
operator contains:
language Language of the SPJ method, which
is always Java.
text
runtime_options UDR_JAVA_OPTIONS setting under
which the CALL statement was
compiled.
text
runtime_option_delimiters A single-quoted string representing
the option delimiter character in the
UDR_JAVA_OPTIONS string, which
is always a single space character.
text
Token Followed by ... Data Type
begin_key Expression of the begin key
predicates
expr(text)