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.
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.