The return clause constructs a new product element for each distinct ProductID value.
return子句为每个不同的productid值构造一个新的“product”元素。
Otherwise, the else clause is evaluated, and DB2 returns an Info element containing only product ID and message data.
否则,执行else子句,DB2返回一个“info”元素,其中只包含产品ID和评语数据。
If the number of tuples, calculated by using the Cartesian product, exceeds the set threshold; the NON EMPTY clause is applied to the query.
如果通过使用Cartesian产品计算的元组数超过设定的阈值,将NON empty子句应用于查询。
应用推荐