DB2 Error SQLERRMC:DECFLOAT... sometimes

sql database db2 sqlcode
Keith Engle picture Keith Engle · Sep 25, 2013 · Viewed 20.7k times · Source

This one really has me scratching my head. This statement:

SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 30

works just fine, but this one:

SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 20

Gives me the

DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECFLOAT, DRIVER=3.57.82

error message, which I understand indicates that the value for PERCENT is malformed. PERCENT has a type of DECIMAL. Anyone have any ideas? 10 also fails, but all numbers above 30 work fine.

Even better, 

SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT < 31 AND PERCENT > 29 works just fine but

SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT < 21 AND PERCENT > 19

yields the same error

Answer

Related questions

How to update multiple columns in single update statement in DB2

I want to update multiple columns of a table in DB2 with single Update statement. Any hint or idea will be appreciable. Thanks.

Read More
Calculating how many days are between two dates in DB2?

I need to get the difference in days between two dates in DB2. I tried a couple of different queries but nothing seems to be working. So basically what i need to get is something like this. SELECT DAYS (CURRENT …

Read More
Does DB2 have an "insert or update" statement?

From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed. My code now does a select and if no result is returned it does an insert. I really don't …

Read More