AS400 Decimal type

Ignition
1

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

2

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

3

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

4

I wonder if this may help.

http://comments.gmane.org/gmane.comp.hardware.ibm.midrange/170590

5

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.