Informix Error -8003: A SMALLINTEGER constant may not be larger than 32767.
Cause and resolution
A SMALLINTEGER constant may not be larger than 32767.
The allowable range of values for a SMALLINT constant is -32,767 through 32,767. Only whole numbers are allowed, with only digit characters.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-8003 fires when a SMALLINT constant in a report specification exceeds the allowable
range — per the official guidance, the range is -32,767 through 32,767, whole numbers only,
digit characters only.
- A
SMALLINTconstant outside -32,767 to 32,767, per the official guidance — the direct, only cause.
Solutions / Resolution
- Correct the constant to fall within -32,767 to 32,767, per the official guidance, using only digit characters.
Examples
An out-of-range SMALLINT constant
LET x = 40000
-- -8003: 40000 exceeds the SMALLINT constant range
Corrected
LET x = 30000
Diagnostic Checks
- Check every
SMALLINTconstant in the report specification, and confirm it falls within -32,767 to 32,767.
Related Errors / Related Topics
- -8004 — "Illegal FLOAT constant." A related constant-format error, for
FLOATrather thanSMALLINTconstants.
A SMALLINT constant exceeds -32,767 to 32,767 — correct it.