db2Parse 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