Conversion error on host variable or parameter *N

sql ibm-midrange
Richipal picture Richipal · Sep 10, 2009 · Viewed 14.3k times · Source

I am getting this Error on Insert statement to AS400 database, using Java with JDBC.

Answer

Richipal picture Richipal · Sep 10, 2009

I figured it out, I had a numeric field with length 4 and decimal digits 2, In my insert I was trying to insert 100 in this numeric field which gave this error.

I altered the table and made it numeric with length 9 and decimal digits 2 
and the insert worked.

even though the error says "Conversion error", actually its the wrong field length.

Related questions

How to do SQL select top N ... in AS400

How do you perform a Select top N * from as400table type query against an as400/db2 database

Read More
GETDATE() method for DB2

I have been trying for a while now to get a similar method to GETDATE() in DB2 for i. So far I have found the following: current date current timestamp current time Would it be possible for me to: select …

Read More
Connect to AS400 using .NET

I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400. What do I have to install on my machine (or the AS400 server) in order to connect? (…

Read More