Informix Error -9625: Alignment must be set to 1, 2, 4 or 8.
Cause and resolution
Alignment must be set to 1, 2, 4 or 8.
When you use the CREATE OPAQUE TYPE statement to define an opaque type, the value that you specify for the alignment modifier must be 1, 2, 4, or 8. Redefine the type with a valid value.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9625 fires when a CREATE OPAQUE TYPE statement's alignment modifier isn't 1, 2, 4, or 8 — per the official guidance.
- An alignment value other than 1, 2, 4, or 8, per the official guidance — the direct, only cause.
Solutions / Resolution
- Redefine the type with a valid alignment value (1, 2, 4, or 8), per the official guidance.
Examples
An invalid alignment
CREATE OPAQUE TYPE my_type (alignment = 3, ...); -- -9625
Corrected
CREATE OPAQUE TYPE my_type (alignment = 4, ...);
Diagnostic Checks
- Check the
alignmentmodifier's value, and set it to 1, 2, 4, or 8.
Related Errors / Related Topics
- -9623 — "Internal length must be greater than zero and smaller than 32,768." A related CREATE OPAQUE TYPE modifier-validity error, on internal length rather than alignment.
- -9624 — "Maximum length must be greater than zero and smaller than 32,768." A related CREATE OPAQUE TYPE modifier-validity error, on maximum length rather than alignment.
The alignment modifier wasn't 1, 2, 4, or 8 — correct it.