Informix Error -35216: WHENEVER clause not allowed when SQLCODE appears in parameter list.

Reasons / Common Causes

-35216 fires when a procedure with a SQLCODE parameter also uses a WHENEVER clause — per the official guidance, these two error-handling styles are mutually exclusive.

1. Both a SQLCODE parameter and a WHENEVER clause present on the same procedure, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Choose either ANSI error handling with SQLCODE or Informix Ada-style error handling, per the official guidance — not both.

Examples

N/A

No specific triggering statement is documented beyond a procedure combining SQLCODE and WHENEVER.

Diagnostic Checks

1. Check whether the procedure has both a SQLCODE parameter and a WHENEVER clause, and remove one.

Related Errors / Related Topics

• -35219 — "At least one (SQLCODE) parameter required by ANSI X3.135-1989." The companion ANSI requirement that makes SQLCODE mandatory in the first place.
• -35206 — "Language must be Ada, instead of language name." Related to the Ada-style error handling this error treats as the alternative to SQLCODE.

A procedure combined SQLCODE-based (ANSI) and WHENEVER-based (Ada-style) error handling — these are mutually exclusive; choose one.