News
Abstract
A table-reference in SQL is enhanced to permit correlation-clause to be optional.
Content
table-reference
A table-reference specifies an intermediate result table.
>>-+-single-table----------------+-----------------------------><
+-nested-table-expression-----+
+-table-function--------------+
+-json_table-expression-------+
+-xmltable-expression---------+
+-data-change-table-reference-+
+-collection-derived-table----+
'-joined-table----------------'
single-table
|--+-table-name-+--+----------------------+--+--------------------+--|
'-view-name--' '-period-specification-' '-correlation-clause-'
nested-table-expression
|--+---------+--(--fullselect--)--+--------------------+--------|
'-LATERAL-' '-correlation-clause-'
table-function
|--TABLE--(--function-invocation--)--+--------------------+-----|
'-correlation-clause-'
json_table-expression
|--json_table-function--+--------------------+------------------|
'-correlation-clause-'
xmltable-expression
|--xmltable-function--+--------------------+--------------------|
'-correlation-clause-'
data-change-table-reference
|----+-FINAL-+--TABLE--(--INSERT statement--)--+--------------------+----|
'-NEW---' '-correlation-clause-'
collection-derived-table
.-,----------------.
V |
|--UNNEST--(----array-expression-+--)--------------------------->
>--+-----------------+--+--------------------+------------------|
'-WITH ORDINALITY-' '-correlation-clause-'
correlation-clause
.-AS-.
|--+----+--correlation-name--+-----------------------+----------|
| .-,-----------. |
| V | |
'-(----column-name-+--)-'
Was this topic helpful?
Document Information
Modified date:
15 January 2020
UID
ibm11116363