db2 Parse comma-separated values in a column into multiple rows
Syntax
- WITH CTE_name (column_name[,...]) AS (
- SELECT column_name[,...] FROM base_table
- UNION ALL
- SELECT column_name[,...] FROM CTE_name
- WHERE <recursion limiting condition>
- )
- SELECT column_name[,...] FROM CTE_name
