Neoview Query Guide (R2.3, R2.4, R2.5)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.5 Software

Miscellaneous Operators

CALL Operator

The CALL operator indicates that a user-defined routine (UDR) was executed. The CALL operator

has no child operators. The description field for this operator contains:

Data TypeToken DescriptionToken

integerA sequential number assigned to the fragment. 0 is always master

executor and 1 is reserved for the Explain plan. Numbers 2 to n will

be ESP or DAM fragments.

fragment_id

integerThe fragment_id for the parent fragment of the current fragment.

Value is (none) for master executor.

parent_frag

textmaster, ESP, or DAMfragment_type

textA sequence of characters that specifies SQL parameter modes for the

procedure. I is used for an IN parameter, O for an OUT parameter,

and N for an INOUT parameter. Characters are separated by a single

space. The value none is returned if the procedure has no SQL

parameters.

parameter_modes

textANSI name of the procedureroutine_name

textSQL access mode of the proceduresql_access_mode

textJava method nameexternal_name

textJava class name, possibly prefixed by a package name, that contains

the SPJ method

external_file

textJava signature of the SPJ method in internal Java Virtual Machine

(JVM) format

signature

textLanguage of the SPJ method, which is always Javalanguage

integerThe maximum number of result sets this procedure can return.max_result_sets

expr(text)Input values to the CALL statement. One expression is returned for

each IN or INOUT parameter. Nothing is returned for OUT

parameters.

input_values

FIRSTN Operator

The FIRSTN operator implements the first or any number of rows functionality. For example,

SELECT [FIRST 2] * FROM T; the operator is used to return the first 2 (or n) rows returned

by the child. This operator is also used to implement the last 0 functionality, which processes all

rows and returns none.