Oninit
Talk to an expert →

Informix Error -26043: Function (explain_sql): The required parameter %s is NULL

Cause and resolution

Function (explain_sql): The required parameter %s is NULL

The required parameter is missing when you execute the explain_sql UDR.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-26043 fires when a required parameter to the explain_sql UDR is null — per the official guidance.

  1. A required parameter missing (null) when calling explain_sql, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Supply a non-null value for the named required parameter, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond a missing required parameter.

Diagnostic Checks
  1. Check every required parameter passed to explain_sql, and confirm none are null.
Related Errors / Related Topics
  • -26042 — "Function (explain_sql) failed in %s." A related explain_sql error, a generic internal-function failure rather than a specific missing parameter.
  • -26048 — "Function (explain_sql) has an invalid parameter %s parameter." A related explain_sql parameter error, on an invalid value rather than a null (missing) one.

A required explain_sql parameter was null — supply a value for it.