https://www.ibm.com/docs/en/db2/11.5.x?topic=queries-connect-by-root
CONNECT_BY_ROOT unary operator
The CONNECT_BY_ROOT unary operator is for use only in hierarchical queries. For every row in the hierarchy, this operator returns the expression for the root...
connect by rootunaryoperator