Oninit
Talk to an expert →

Informix Error -2032: The number above could not be successfully converted to either an INTEGER or a DOUBLE or a LONG.

Cause and resolution

The number above could not be successfully converted to either an INTEGER or a DOUBLE or a LONG.

Something is wrong with the numeric constant; probably it has too many digits. Check the punctuation of the statement; possibly two numbers have been run together.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2032 fires when a numeric constant can't be converted to INTEGER, DOUBLE, or LONG — per the official guidance, this is likely due to excessive digits, often from two numbers being unintentionally concatenated.

  1. A numeric constant with too many digits to fit any of the three types, per the official guidance — the direct, likely cause.
  2. Missing or misplaced punctuation concatenating two separate numbers together, per the official guidance's suggested check — the same class of mistake as -1216's illegal-exponent condition.
Solutions / Resolution
  1. Check punctuation in the statement, per the official guidance, for two numbers that may have run together.
Examples
Two numbers concatenated by a missing comma
DEFAULT = (100 200)
-- -2032: missing comma parsed "100 200" as a single, oversized number in some contexts
Corrected
DEFAULT = (100, 200)
Diagnostic Checks
  1. Re-read the statement for a missing or misplaced punctuation mark that might have merged two separate numbers into one.
Related Errors / Related Topics
  • -1216 — "Illegal exponent." A related numeric-literal error, from the same class of punctuation mistake merging two numbers together.

A numeric constant couldn't convert to any supported type, likely from two numbers concatenated by missing punctuation — check for that first.