Hi, I'm trying to run a SQL query against an Informix db and keep receiving an error 1226 "Decimal or money value exceeds maximum precision. <0>". The fields that are giving me the error are defined as decimal(2,0) and are only storing integer data (range 1 - 10). I can pull data from fields stored as integers just fine. Could my problem be with this specific datatype?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL error 1226 & Datatypes
- Thread starter ks1392
- Start date