# AS400 Decimal type

**URL:** <https://forum.inductiveautomation.com/t/as400-decimal-type/10623>\
**Category:** Ignition\
**Created:** [October 14, 2015, 5:25pm UTC](https://forum.inductiveautomation.com/t/as400-decimal-type/10623 "2015-10-14T17:25:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Polynomial](https://avatars.discourse-cdn.com/v4/letter/p/848f3c/32.png) [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\
**Post date:** [October 14, 2015, 5:25pm UTC](https://forum.inductiveautomation.com/t/as400-decimal-type/10623/1 "2015-10-14T17:25:30Z")

</div>

Hello,

I’m trying to call a stored procedure on an AS400 database using the jt400 jdbc driver. The stored procedure has some decimal input variables, e.g. DECIMAL(7,2). It keeps failing and says there’s no procedure that matches my call. I’m wondering if I’m using the right system.db.DECIMAL variable in the call.

Has anyone done this before?

Thanks

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [October 14, 2015, 6:19pm UTC](https://forum.inductiveautomation.com/t/as400-decimal-type/10623/2 "2015-10-14T18:19:48Z")

</div>

Are you sure you have the stored procedure name correct? It may also be case sensitive.

---

<div class="post-metadata">

**Author:** ![Polynomial](https://avatars.discourse-cdn.com/v4/letter/p/848f3c/32.png) [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\
**Post date:** [October 14, 2015, 6:22pm UTC](https://forum.inductiveautomation.com/t/as400-decimal-type/10623/3 "2015-10-14T18:22:10Z")

</div>

The parameter names are all correct according to our contact. Unfortunately I don’t have direct access to the database.

---

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [October 15, 2015, 12:24pm UTC](https://forum.inductiveautomation.com/t/as400-decimal-type/10623/4 "2015-10-15T12:24:02Z")

</div>

I wonder if this may help.

[http://comments.gmane.org/gmane.comp.hardware.ibm.midrange/170590](http://comments.gmane.org/gmane.comp.hardware.ibm.midrange/170590)

---

<div class="post-metadata">

**Author:** ![Polynomial](https://avatars.discourse-cdn.com/v4/letter/p/848f3c/32.png) [@Polynomial](https://forum.inductiveautomation.com/u/Polynomial)\
**Post date:** [October 16, 2015, 6:39pm UTC](https://forum.inductiveautomation.com/t/as400-decimal-type/10623/5 "2015-10-16T18:39:24Z")

</div>

We experimented with BigDecimal from the java math library which was looking promising. Our client provided us with a char based procedure that we ended up using though.