Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Claus Samuelsen — — source: Informix-list mailing list archive (1991-1998)
Kate_Tomchik@HomeDepot.COM wrote:
>
> We are getting the following errors when we try to select a database from
> dbaccess:
>
> -7203 DBNLS is not set or LC_COLLATE must be category-value.
>
> This message may be returned when you try to access an external
> database that has a different locale than the current database. In
> order to use this NLS database, you must set the DBNLS environment
> variable to 1 or 2 and the LC_COLLATE environment variable to the
> specified category-value.
>
> -117 ISAM error: bad custom collating sequence.
>
> This message is not displayed by any current Informix product. If
> the error recurs, please note all circumstances and contact the
> Informix Technical Support Department.
>
> What does this mean? Any suggestions on how to help?
This probably means that your database was created the following
environment variables set: LANG=xx_xx and DBNLS=1.
If LANG is set to something like en_US the set DBNLS to 2 and try and
connect again.
NLS information is stored in the database at creation time when DBNLS
is set to 1. You can find the information in the systables table where
tabid = 90 and 91.
best regards
--
+-------------------------------------------------------------+
| Claus Samuelsen Sysdeco Danmark A/S |
| Project Manager Gydevang 22B |
| email: csa@sysdeco.dk DK-3450 Aller'd |
| phone: +45 4814 3000 Denmark |
+-------------------------------------------------------------+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.