I am running SQL in an RPG, inserting rows into an IBM file, and getting this error -406
A numeric value is out of range.
A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN
However, if I paste the code into Navigator and insert into the same IBM file, it runs without error.
And if I run it with results to a query window and order by the numeric fields, I don't see anything that looks wrong.
Any Thoughts ??
EDIT: SOLVED
A numeric value is out of range.
A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS OBJECT COLUMN
However, if I paste the code into Navigator and insert into the same IBM file, it runs without error.
And if I run it with results to a query window and order by the numeric fields, I don't see anything that looks wrong.
Any Thoughts ??
EDIT: SOLVED
Comment