How to split columns into rows in DB2?
<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>