Informix Error -25775: Max Records to Retrieve parameter must be from 0 to 9,999.
Cause and resolution
Max Records to Retrieve parameter must be from 0 to 9,999.
The specified value is incorrect. Change the value to within the accepted range.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25775 fires when the Max Records to Retrieve parameter is outside 0-9,999 — per the official guidance.
- A Max Records to Retrieve value outside the accepted range, per the official guidance — the direct, only cause.
Solutions / Resolution
- Change the value to within the accepted range, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an out-of-range value.
Diagnostic Checks
- Check the Max Records to Retrieve value, and set it within 0-9,999.
Related Errors / Related Topics
- -25774 — "Max Records to Process parameter must be from 1 to 99,999,999." A related configuration-range error, on the process limit rather than the retrieve limit.
- -25783 — "Value in SIZE clause is invalid." A related retrieve-limit error, sharing
the same 1-9,999 acceptable range, in an
EXTRACTstatement'sSIZEclause. - -25784 — "Value in SIZE clause is out of range." A related retrieve-limit error.
The Max Records to Retrieve parameter was out of range — set it within 0-9,999.