Oninit
Talk to an expert →

Informix Error -35219: At least one (SQLCODE) parameter required by ANSI X3.135-1989.

Cause and resolution

At least one (SQLCODE) parameter required by ANSI X3.135-1989.

ANSI standards require that each procedure have at least one SQLCODE parameter.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-35219 fires when an ANSI-compliant procedure has no SQLCODE parameter — per the official guidance, ANSI X3.135-1989 standards require at least one.

  1. No SQLCODE parameter present, per the official guidance, on a procedure being compiled under ANSI standards — the direct, only cause.
Solutions / Resolution
  1. Add at least one SQLCODE parameter to the procedure, per the official guidance.
Examples
N/A

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

Diagnostic Checks
  1. Check the procedure's parameter list for a SQLCODE parameter and add one if missing.
Related Errors / Related Topics
  • -35206 — "Language must be Ada, instead of language name." Another ANSI X3.135-1989 compliance requirement.
  • -35217 — "Language clause required by ANSI X3.135-1989." Another ANSI X3.135-1989 compliance requirement.
  • -35218 — "Authorization clause required by ANSI X3.135-1989." Another ANSI X3.135-1989 compliance requirement.
  • -35216 — "WHENEVER clause not allowed when SQLCODE appears in parameter list." A related restriction on SQLCODE-parameter procedures, about WHENEVER rather than presence.

An ANSI-compliant procedure was missing its required SQLCODE parameter — add at least one.