Informix Error -8126
Cause and resolution
PARAM[0] may not be defined.
The first parameter that you can define in the PARAMETER statement is number 1. In some host-operating systems, the zeroth parameter is preset to the program name, but this value is not available within a report.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-8126 fires when PARAM[0] is defined — per the official guidance, the first definable
parameter is number 1; the zeroth parameter (program name, on some host systems) isn't
available within a report.
PARAM[0]defined in thePARAMETERstatement, per the official guidance — the direct, only cause.
Solutions / Resolution
- Start parameter numbering at 1, per the official guidance.
Examples
Defining PARAM[0]
PARAM
0: order_id INTEGER
-- -8126: parameter numbering must start at 1
Corrected
PARAM
1: order_id INTEGER
Diagnostic Checks
- Check the
PARAMETERstatement's numbering, and confirm it starts at 1, not 0.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -8126 in this set yet.
PARAM[0] was defined, but parameter numbering must start at 1.