SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
7-35
LEFT_HYBRID_HASH_JOIN Operator
The following is an example of the INSERT_VSBB operator:
control query default insert_vsbb 'USER';
prepare TestQuery35 from
Insert NOLOG into Dup_B
Values
(1001,'www','I1'),(1004,'wwt','aa'),(1005,'rrr','B1'),(1007,'qqq
','ff'),(1010,'ppp','gg'),
(1011,'nlmlm','zz'),(1013,'naaa','ff'),(1015,'lll','nn'),(1016,'
iii','uu'),(1017,'hhh','PP'),(1026,'gggggg','y'),
(1035,'fff','ii'),(1037,'eeee','w'),(1040,'ddd','kk');
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
olt_optimization ....... not used
olt_opt_lean ........... not used
iud_type ............... insert_vsbb DETCAT.DETSCH.DUP_B
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 3
new_rec_expr ........... (PRIM assign cast(%(1040) AS INTEGER
SIGNED)),(PRIM2 assign
cast(%('ddd') AS VARCHAR(20)
CHARACTER SET ISO88591)),
(CH assign cast(cast(cast(%('kk')
AS CHAR(2) CHARACTER SET ISO88591)
AS VARCHAR(8) CHARACTER
SET ISO88591) AS CHAR(2) CHARACTER
SET ISO88591))
LEFT_HYBRID_HASH_JOIN Operator
Join Group
The LEFT_HYBRID_HASH_JOIN operator returns an unmatched outer row even when
it does not find a match in the inner table. Null values are supplied for the missing inner
rows. The LEFT_HYBRID_HASH_JOIN operator differs from the
HYBRID_HASH_JOIN only when it does not find a match in the inner table. See
HYBRID_HASH_JOIN Operator on page 7-27.
new_rec_expr Computation of the row to be inserted. expr(text)
part_key_predicate Predicate expression specified on partitioning
key. It is displayed only if partitioning key
differs from clustering key.
expr(text)
check_constraint Check constraints in the insert table. expr(text)
TP663851.fm Page 35 Monday, October 17, 2011 11:48 AM