SAP HANA supports CTE but not recursive SQL (no DECODE too).
The only way to do this is via SQL Script table variables (if restricted/defined in levels) procedural (Looping if indefinite levels or complex nesting rendering difficult maintenance in the future) or via separate Wrapper & Executor procedures.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.