Our APP "MAPCON" is a highly indexed system (BTREE). We use a special delimter ANSI 0240 within our symbolics to create our indexes for lookups. These lookups have been installed and working for years, even in our AREV app. Recently when we rebuild our indexes, in OI, this character is being swapped out to another character, 168 or something close. If we attach and re-build through AREV everthing is peachy but not in OI. This is only on our development system, deployed systems are fine. We do not know why, nothing has changed. Has our character set become corrupt or changed. How do we change or replace it if so? We are stumped currently, this has worked for at least 5 years.

Brock,

Character sets are in the SYSENV table. You find the relevant rows among the ENV_… (application environment), LND_… (language), and CM_… (collation sequence) rows. Perhaps you could just try and replace the whole of SYSENV? Or you could carefully inspect the relevant rows. Start with the ENV_ rows and find out which LND_… rows they use. Study those LND_… rows for differences (well, not everything has to do with language). If they refer to CM_… rows compare those too. (But don't try to edit CM_… rows directly.)

- Oystein -

Oystein,

Thanks, that lead me to the problem. Our ENV_SYSPROG record had somehow been copied to our ENV_MAPCON record. As I said this ha s been working for years, I don't know how this happened. But, any way it is fixed.

Thanks again,

Brock Prusha

View this thread on the Works forum...