Oninit
Talk to an expert →

Informix Error -29036

-29036 Character codeset conversion file not found from, to, filename:

from_cs_num, to_cs_num, filename.

filename The filename of the code-set conversion file that could not be found.

from_cs_num The code-set number for the source code set.

to_cs_num The code-set number for the target code set.

A code-set conversion table to convert from the code set that from_cs_num identifies to the code set that to_cs_num identifies was not found. Consult your IBM Informix product documentation to find descriptions for the code sets that these code-set numbers identify.

If the appropriate directory (see next paragraph) does not contain the code-set conversion file named filename, this code-set conversion cannot be performed. Check your IBM Informix product documentation to make sure that the code sets that the client and server products use have been specified correctly (using environment variables or other mechanisms that are described in the documentation). Perhaps the code-set numbers have been incorrectly specified or are equivalent to other code-set numbers that are supported.

If the code-set conversion table exists, verify that your product was installed correctly so that the conversion table file can be located. Specifically, ensure that the GL_PATH environment variable is set or not set according to the installation instructions.

* If GL_PATH is not set, verify that the conversion table file is in the $INFORMIXDIR/gls/cv directory.

* If GL_PATH is set, verify that the conversion table file is in one of the directories that the GL_PATH environment variable specifies.

If the code-set conversion table does not exist, contact your IBM Informix software distributor for assistance in determining what code-set conversion tables are required for your configuration. If the required code-set conversion tables are available, place the tables in the appropriate directory.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29036 fires when the code-set conversion table needed to convert between two code sets can't be found — per the official guidance, from_cs_num/to_cs_num identify the code sets and filename the missing table file.

  1. The named conversion table file missing from the expected directory, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Verify the client/server code sets are specified correctly, per the official guidance, checking for incorrect or equivalent code-set numbers.
  2. Check GL_PATH, per the official guidance — if unset, verify the file is in $INFORMIXDIR/gls/cv; if set, verify it's in one of GL_PATH's directories.
  3. If the table genuinely doesn't exist, contact your IBM Informix software distributor, per the official guidance, and place the needed table in the correct directory once obtained.
Examples
N/A

No specific triggering statement is documented beyond a missing conversion table file.

Diagnostic Checks
  1. Check GL_PATH and the expected conversion-table directory for the named file, and verify the code-set numbers are correctly specified.
Related Errors / Related Topics
  • -29032 — "Application Server CCSIDs could not be determined." A related code-set configuration error, on undetermined CCSIDs rather than a missing conversion table.
  • -29034 — "Character code-set conversion error. Tokens: from-cs-num, to-cs-num, cftype, objtype, position." A related code-set error, on a conversion-time failure rather than a missing table file.

A code-set conversion table file wasn't found — check GL_PATH/the conversion-table directory and the code-set numbers' correctness.