Oninit
Talk to an expert →

Informix Error -1380

Cause and resolution

Only character expressions may be CLIPPED.

You cannot CLIP a noncharacter expression.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1380 fires when CLIPPED is applied to a non-character expression — per the official guidance, the CLIP operation only works on character-based data.

  1. CLIPPED applied to a numeric, date, or other non-character expression, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Remove CLIPPED from the non-character expression, or convert the value to a character type first, if trimming trailing whitespace from its string representation is genuinely the intent.
Examples
CLIPPED applied to a numeric value
DISPLAY order_total CLIPPED
-- -1380: order_total is DECIMAL, not a character expression
Corrected
DISPLAY order_total USING "###&.&&" CLIPPED
-- format to a string first, then CLIPPED applies to that character result
Diagnostic Checks
  1. Check the data type of the expression CLIPPED is applied to, and confirm it's character-based.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -1380 in this set yet.

CLIPPED was applied to a non-character expression — convert to a character type first, or remove CLIPPED.