Listing 14 shows the DB2 equivalent using UNNEST.
清单14显示了使用UNNEST的DB 2等效项。
The UNNEST operator in SQL PL makes such an operation possible.
SQLPL中的 UNNEST运算符使此类操作成为可能。
To make such conversions between arrays and tables possible, DB2 provides the new ARRAY_AGG function and UNNEST operator.
要使阵列和表之间的转换成为可能，DB 2要提供新的array_agg函数和UNNES t运算符。
The WITH ORDINALITY clause causes UNNEST to generate an additional column of type integer that contains the position associated with each element.
WITH ORDINALITY子句使UNNEST生成另一个整数类型的列，包含与每一个元素关联的位置。
In its most general form, UNNEST can take several arrays as arguments, and it can produce an additional column to reflect the order imposed by the sub-indexes.
在其最一般的形式中，UNNEST可采用几个阵列作为参数，且其可生成其他列以便反映子索引实施的顺序。
DB2 doesn't provide direct equivalents to these operations, but the most common USES of FORALL and BULK COLLECT can be efficiently mapped to statements involving UNNEST and ARRAY_AGG, respectively.
DB 2不提供这些操作的直接等效操作，但是FORALL和BULKCOLLECT的最常见使用可有效地分别映射到涉及UNNEST和ARRAY_AGG的语句。
DB2 doesn't provide direct equivalents to these operations, but the most common USES of FORALL and BULK COLLECT can be efficiently mapped to statements involving UNNEST and ARRAY_AGG, respectively.
DB 2不提供这些操作的直接等效操作，但是FORALL和BULKCOLLECT的最常见使用可有效地分别映射到涉及UNNEST和ARRAY_AGG的语句。
应用推荐