Conversion error on host variable or parameter *N

Question

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

Answer 1

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.

Answer 2

I ran in to this issue when a table was updated from 2 digits to 3 for user ID's and the query inserts in to a history table where the history table was not updated to 3 digits for the user id. Used Alter Table to correct the history table and all is well.

alter table "Table Name" ALTER COLUMN "COLUMN NAME" SET DATA TYPE NUMERIC(3)

The error message is not intuitive:

Conversion error on variable or parameter *N (#-302) [IBM][System iAccess ODBC Driver][DB2 for i5/OS]SQL0012 - Correlation without qualification occurred for column "columnname" to table "Tablename". (#12)