Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CLI0111E Numeric value out of range - Prepared Statement problem

Status
Not open for further replies.
acapellacci

acapellacci

IS-IT--Management
Oct 18, 2007
1
IT
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
 
Status
Not open for further replies.

Similar threads

Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
176
Thomas B
Thomas B
evr72
  • Locked
  • Question
Get last field value into next row
Replies
6
Views
195
SkipVought
S
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
138
Rohit K Gupta
Rohit K Gupta
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
185
pratimsingha
pratimsingha
usr1234
  • Locked
  • Question
does the setting PARALLEL_DEGREE=*OPTIMIZE helps the execution of an ALTER TABLE ?
Replies
0
Views
131
usr1234
usr1234

Part and Inventory Search

Sponsor

Back
Top