SYSIQJOINIXCOLUMN System View

Presents group information from ISYSIQJOINIXCOLUMN in a readable format. Each row in the SYSIQJOINIXCOLUMN view describes an IQ join index.

ALTER VIEW "SYS"."SYSIQJOINIXCOLUMN"
as select * from SYS.ISYSIQJOINIXCOLUMN

Column name

Column type

Description

joinindex_id

unsigned bigint

Corresponds to a join index value in SYSIQJOINIDX.

left_table_id

unsigned int

Corresponds to a table value in SYSTAB that forms the left side of the join operation.

left_column_id

unsigned int

Corresponds to a column value in SYSTABCOL that is part of the left side of the join.

join_type

char(4)

Only value currently supported is “=”.

right_table_id

unsigned int

Corresponds to a table value in SYSTAB that forms the right side of the join operation

right_column_id

unsigned int

Corresponds to a column value in SYSTABCOL that is part of the right side of the join.

order_num

unsigned int

For internal use.

left_order_num

unsigned int

For internal use.

right_order_num

unsigned int

For internal use.

key_type

char(8)

Defines the type of join on the keys. ‘NATURAL’ is a natural join, ‘KEY’ is a key join, ‘ON’ is a left outer/right outer/full join.

coalesce

char(1)

Not used.

Constraints on underlying system table:

Primary key (joinindex_id, left_table_id, left_column_id, right_table_id, right_column_id)

Foreign key (joinindex_id) references SYS.ISYSIQJOINIDX

Foreign key (left_table_id, column_id) references SYS.ISYSTABCOL

Foreign key (right_table_id, column_id) references SYS.ISYSTABCOL