ALTER VIEW "SYS"."SYSIQJOINIXCOLUMN" as select * from SYS.ISYSIQJOINIXCOLUMN
Presents group information from ISYSIQJOINIXCOLUMN in a readable format. Each row in the SYSIQJOINIXCOLUMN view describes an IQ join index.
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
