Oninit
Talk to an expert →

Informix Error -8130: An INTEGER constant may not be larger than 2147483647.

Cause and resolution

An INTEGER constant may not be larger than 2147483647.

This statement specifies a value that cannot be contained in an integer. Either use a smaller value or a different data type (for example, DECIMAL).

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8130 fires when an INTEGER constant exceeds 2,147,483,647 — per the official guidance, this value can't be contained in an integer.

  1. An INTEGER constant greater than 2,147,483,647, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Use a smaller value, per the official guidance, or
  2. Use a different data type (for example, DECIMAL), per the official guidance.
Examples
An oversized INTEGER constant
LET x = 9999999999
-- -8130: exceeds the INTEGER maximum of 2147483647
Corrected
DEFINE x DECIMAL(15,0)
LET x = 9999999999
Diagnostic Checks
  1. Check the constant's value, and either reduce it or switch to DECIMAL.
Related Errors / Related Topics
  • -8003 — "A SMALLINTEGER constant may not be larger than 32767." The equivalent constant-range restriction, for SMALLINT rather than INTEGER.

An INTEGER constant exceeds 2,147,483,647 — reduce it or use DECIMAL.