IBM Books

What's New


Messages

SQLSTATE 22003 - Numeric value out of range

Before DB2 UDB Version 5.2 when converting integer to float data types:

a number of functions returned SQLSTATE 22003 - Numeric value out of range, if the integer contained more significant digits than the float could handle.

This is not correct according to the ODBC or SQL standard. Beginning with DB2 UDB v5.2, the error will not be returned in this case.

See 'Appendix E. SQLSTATE Cross Reference' of the CLI Guide and Reference for a list of CLI functions that return this SQLSTATE.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]