title: How to split columns into rows in DB2?
body: <p>My sample query returns the below data. I want to split the column data to rows.</p>
  
  <p>I do not want to use <code>UNION ALL</code> as my query is very complex. Is there any other way to accomplish this? I am using DB2.</p>
  
  <pre><code>Current:
  SKU_NBR   STR_NBR   ADDL_ORD_QTY    TRGT_OH_QTY   BUMP_INCR_QTY
  301701     1902        60                40           20
  346989     1902        60                             20
  
  Expected:            
  SKU_NBR     STR_NBR    Demand    
  301701      1902        60   
  301701      1902        40   
  301701      1902        20   
  346989      1902        60   
  346989      1902       null  
  346989      1902        20   
  </code></pre>