title: DB2: Unable to set 'Default' value
body: <p>I am new to <code>DB2</code>. So please bear with me. Below is the query being used to fetch the data. The intention is to set "Default" value if nothing is found:</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT t1.col1,t1.col2,t1.col3,t1.col4,t1.col5 FROM TABLE t1 FETCH FIRST 5 ROWS ONLY;
  </code></pre>
  
  <p>What I tried:</p>
  
  <pre><code>SELECT t1.col1,t1.col2,t1.col3,t1.col4 SET DEFAULT 'Data Missing',t1.col5 FROM TABLE t1 FETCH FIRST 5 ROWS ONLY;
  
  SELECT t1.col1,t1.col2,t1.col3,COALESCE(t1.col4 SET,'Data Missing'),t1.col5 FROM TABLE t1 FETCH FIRST 5 ROWS ONLY;
  
  SELECT t1.col1,t1.col2,t1.col3,COALESCE(t1.col4 SET,0),t1.col5 FROM TABLE t1 FETCH FIRST 5 ROWS ONLY;
  
  SELECT t1.col1,t1.col2,t1.col3,t1.col4 NOT NULL DEFAULT 'Data Missing',t1.col5 FROM TABLE t1 FETCH FIRST 5 ROWS ONLY;
  </code></pre>
  
  <p>But, none of these is working.</p>
  
  <p>In MySQL, I can achieve the same by:</p>
  
  <pre><code>SELECT t1.col1,t1.col2,t1.col3,t1.col4 NOT NULL DEFAULT 'Data Missing', t1.col5 FROM TABLE t1 LIMIT 5;
  </code></pre>
  
  <p>Update_1:Tried below</p>
  
  <pre><code>select col1,
  case
  when col4 is null then 'Data Missing' else col4 end as col4
  when col3 is null then 'Data Missing' else col3 end as col3
  when col2 is null then 'Data Missing' else col2 end as col2
  from my_table
  fetch first 5 rows only;
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>1) [Code: -104, SQL State: 42601]  An unexpected token "WHEN" was found following "END AS COL4
  ".  Expected tokens may include:  "INTO".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.22.29
  
  2) [Code: -727, SQL State: 56098]  An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "WHEN|END AS COL4
  </code></pre>