Neoview Query Guide (R2.2)

Data TypeToken DescriptionToken
textDetermines the type of statement atomicity chosen for a query:
XN_ROLLBACK: Transaction is rolled back if an error occurs.
NO_XN_ROLLBACK: Upon error, query stops executing and error is
returned. Transaction is NOT rolled back. Only appears if you request
a WITH NO ROLLBACK type of transaction. RETURN: Query stops
executing and error is returned without need for statement rollback.
SAVEPOINT: DAM savepoints are used to roll back the statement if an
error occurs. PARTIAL_UPD: Partial results are updated and an error
is returned.
upd_action_on_error
textAppears only if text is READ ONLY. READ ONLY transactions are
obtained for select statements when autocommit is ON, or if you have
requested it through a SET TRANSACTION statement.
xn_access_mode
intThe transaction autoabort interval. -1 means autoabort interval as
configured for the entire system. 0 means the transaction never auto
aborts. Any other value means the number of seconds after which the
transaction will auto abort. Legal values are in the range 20 to 21474836
seconds.
xn_autoabort_interval
intVersion number associated with the plan. Value is 2020 for plans
generated by the Neoview SQL R2.2compiler.
plan_version
expr(text)Expression of the SELECT list columnsselect_list
expr(text)Expression containing list of input variables (params)input_variables
expr(text)Expression containing list of sort keysorder_by
expr(text)The update column specification of an updatable cursor declarationupdate_col
text
The ESP allocation map for the ith fragment in the query plan. The
fragment ID is indicated for each operator in the EXPLAIN output.
esp_i_node_map
intThe value used by the compiler for the ESP placement for this query.affinity_value
ESP_EXCHANGE Operator
An ESP_EXCHANGE operator describes a portion of an execution plan that redistributes the
input data stream. This operator serves as a process boundary and represents an interface between
ESPs, between the master executor and one or more ESPs, or between an ESP process and a DAM
process. This operator and all operators subordinate to it execute inside an ESP until another
process boundary is reached. For more information about exchange operators, see Chapter 2
(page 19).
The ESP_EXCHANGE operator has one child operator. 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
integerSize of message bufferbuffer_size
integerNumber of bytes in the record sentrecord_length
integerNumber of top ESP processesparent_processes
integerNumber of bottom ESP processeschild_processes
34 Query Plan Operators