IBM Support

Table correlation name enhanced to be optional

News


Abstract

A table-reference in SQL is enhanced to permit correlation-clause to be optional.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements >  Table correlation name enhanced to be optional

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-+--)-'   

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
15 January 2020

UID

ibm11116363