<div>
<div class="content wysiwyg-content">
I am trying to cast as Integer column to Decimal but it is not working for any number other than 0.<br />
<br />
Cast((COALESCE(td.BILL_1_C<wbr />NT ,0)* 1.00) AS DECIMAL(31,2)) as Denomination_Amount
</div>
</div>


I am trying to cast as Integer column to Decimal but it is not working for any number other than 0.

Cast((COALESCE(td.BILL_1_CNT ,0)* 1.00) AS DECIMAL(31,2)) as Denomination_Amount

DB2 Integer to Decimal

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.