Default Value for NOT NULL VARCHAR in DB2
<p>I have a RDBMS table in DB2 where a column is defined as <code>"ARMTST"  VARCHAR(10) NOT NULL    DEFAULT</code> </p>

<p>I was checking data on table and see rows with no value in this column ( Via <code>Toad Viewer</code>)  but when I run this query , <code>SELECT COUNT ( * ) FROM ACTIVITY WHERE ARMTST IS NULL;</code>   I get result as <code>zero rows</code>.  </p>

<p>Attached is screen shot for <code>SELECT ARMTST FROM ACTIVITY ;</code> which shows empty column values for certain rows. </p>

<p>Are these columns not empty even though shown so in UI? Default value is not specified in <code>CREATE TABLE</code> script. </p>

<p>I don't think that code will be able to insert empty values. </p>

<p><a href="https://i.stack.imgur.com/c87C8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/c87C8.png" alt="DB Data"></a></p>