title: kdb+: replace null integer with 0
body: <p>Consider the following table:</p>
  
  <pre><code>myTable:
  
  a     b
  -------
  1     
  2
  3     10
  4     50
  5     30
  </code></pre>
  
  <p>How do I replace the empty cells of <code>b</code> with a zero? So the result would be:</p>
  
  <pre><code>a     b
  -------
  1     0
  2     0
  3     10
  4     50
  5     30
  </code></pre>
  
  <p>Right now I'm doing:</p>
  
  <pre><code>myTable: update b:{$[x~0Ni;0;x]}'b from myTable
  </code></pre>
  
  <p>But I am wondering whether there is a better/easier solution for doing this.</p>