Oninit
Talk to an expert →

Informix Error -29037: There is no CCSID or GLS locale set for the FE OS locale localename.

Cause and resolution

There is no CCSID or GLS locale set for the FE OS locale localename.

The locale in question is returned as a token in SQLERRM.

Notify the Gateway administrator. The administrator can add an entry for the locale using the gwdba utility.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29037 fires when no CCSID or GLS locale is configured for the front-end OS locale named — per the official guidance, the locale name is returned as a token in SQLERRM.

  1. No CCSID/GLS locale entry configured for the named front-end OS locale, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Notify the Gateway administrator, per the official guidance, who can add an entry for the locale using the gwdba utility.
Examples
N/A

No specific triggering statement is documented beyond a missing locale configuration.

Diagnostic Checks
  1. Extract the locale name from SQLERRM, and have the Gateway administrator add it via gwdba.
Related Errors / Related Topics
  • -29033 — "Informix GLS locale could not be loaded: localename, errno, locale-file-name." A related GLS-locale error, on a configured locale that fails to load rather than no locale being configured at all.

No CCSID/GLS locale was configured for the front-end OS locale — the Gateway administrator must add one via gwdba.