Ansicht
Dokumentation

ABENHIER_DESC_AGG_WITH_ABEXA - HIER DESC AGG WITH ABEXA

SELECT, Hierarchy Navigator HIERARCHY_DESCENDANTS_AGGREGATE with WITH

This example demonstrates the hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE with the addition JOIN and the addition WITH.

Source Code

Execute

Description

This example demonstrates the way the different WITH additions work in the hierarchy navigator HIERARCHY_DESCENDANTS_AGGREGATE. The source is a hierarchy joined with another data source by the JOIN addition. Before the function is called, the result set of a join is produced containing all rows to which the WITH additions are applied. Depending on the value entered for the host variable level used in the WHERE condition, the additions WITH SUBTOTAL and WITH BALANCE return different results. The results of WITH NOT MATCHED and WITH TOTAL are independent of level.

The function COALESCE is used here to highlight the null values in the output. If this function is not used, the null values are converted to type-dependent initial values and hence cannot be detected as null values.