title: AS400 thousand delimiter on numeric field
body: <p>Is there a way to get a number formatted with a comma for thousand in numbers?</p>
  
  <p>According to IBM documentation, this is the syntax:</p>
  
  <pre><code>DECIMAL(:newsalary, 9, 2, ',')
  </code></pre>
  
  <p>newsalary is the string (field)
  9 is the precision
  2 is the scale
  , is the delimiter.</p>
  
  <p>I tried:</p>
  
  <pre><code>SELECT DECIMAL ( T1.FIELD1 , 15 , 2 , "," ) AS TOTAL FROM TABLE T1
  </code></pre>
  
  <p>When trying it, I am getting the following error:</p>
  
  <blockquote>
    <p>Message: [SQL0171] Argument 4 of function DECIMAL not valid.</p>
  </blockquote>