title: How to concat an integer value with a string in DB2 procedure
body: <p>I have a variable, <code>price dec(5,0)</code>. How can I concat a static string "dollar" to that and save as a <code>char(10)</code>?</p>
  
  <p>If the price is 55555, the result should be 55555 Dollar and this should be saved as a <code>char(11)</code>.</p>
  
  <p>How can I do it? I tried casting and just concat using '+', but it was not working.</p>