Informix Error -2951: The left and right delimiters must be specified in a two character string.

Reasons / Common Causes

-2951 fires when a DELIMITERS instruction doesn't supply exactly two characters — per the official guidance, DELIMITERS requires a string of exactly two characters (the left and right marker characters used when displaying fields); the two characters can be the same, but there must be two of them.

1. A DELIMITERS string with fewer or more than two characters, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Specify exactly two characters in the DELIMITERS string, per the official guidance — they may be identical, but the string's length must be exactly two.

Examples

A one-character DELIMITERS string

DELIMITERS "["
-- -2951: only one character supplied

Corrected

DELIMITERS "[]"

Using the same character for both delimiters

DELIMITERS "::"

Diagnostic Checks

1. Check the DELIMITERS string's length, and correct it to exactly two characters.

Related Errors / Related Topics

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

The DELIMITERS instruction's string isn't exactly two characters — supply exactly two (they may match).