Informix Error -33047
-33047 Record record-name is not allowed in this clause.
In this statement, you use the specified record where only a simple variable is allowed. Check the spelling of names and rewrite the statement using a simple variable. See the embedded-language manual and the IBM Informix Guide to SQL: Syntax.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-33047 fires when a record is used in a clause that requires a simple variable — per the official guidance.
- A record used where only a simple variable is allowed, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check the spelling of names, and rewrite the statement using a simple variable, per the official guidance, consulting the embedded-language manual and the IBM Informix Guide to SQL: Syntax.
Examples
N/A
No specific triggering statement is documented beyond a record used where a simple variable is required.
Diagnostic Checks
- Check the flagged clause for a record reference, and rewrite it to use a simple variable (or a qualified record member).
Related Errors / Related Topics
- -33014 — "Illegal use of record/structure variable-name." A closely related error, the same class of record/simple-variable restriction.
A record was used where only a simple variable is allowed — rewrite the statement using a simple variable or a qualified member.