db2 Parse comma-separated values in a column into multiple rows

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9

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


Got any db2 Question?