title: How to solve DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502
body: <pre><code>2015-08-28 18:12:19.047-Fri Aug 28 18:12:19 IST 2015DB2 Connection established --&gt;com.ibm.db2.jcc.t4.b@c26e4a
  2015-08-28 18:12:20.030-Execution failed ======&gt; alter table BLP.COUNTER_EXTRACTION_REQUEST alter column SCHEME_ID set not null
  2015-08-28 18:12:20.032-Error code for failure ======&gt; DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=SCHEME_ID, DRIVER=3.63.123
  2015-08-28 18:12:20.044-Execution failed ======&gt; alter table BLP.COUNTER_EXTRACTION_REQUEST alter column SCHEME_TYPE set not null
  2015-08-28 18:12:20.044-Error code for failure ======&gt; DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=SCHEME_TYPE, DRIVER=3.63.123
  </code></pre>