Hi all,

the following error occurs when I try to execute an update using Prepared Statement with more then 142 parameters.

[IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003

The same update worked fine with 141 parameters but when I modified it inserting a new colunm it didn't work anymore.
It seems the number of parameters is limited to 142.

Is there anyone who can confirm it or who knows possible causes and solutions?

Thanks in advance

Here are some details of the environment in use

Dev. environment: Visual Age 4.0
Application Server: IBM WebSphere Test Environment 3.5.3
JDK: 1.2.2
Database: DB2 7.0

What year are you living in, 1999?

Seriously though, if you are interested in meaningful answers you may want to begin with posting the exact SQL statement you are trying to execute and the definition of the table you are updating.