SYNSEL_NUMALPHA_KEYS

Disable type mismatch processing

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX
VSupported on OpenVMS

The SYNSEL_NUMALPHA_KEYS environment variable disables type mismatch processing in 10.3.3d and higher.

Value

Any value.

Discussion

To avoid the possibility of not matching records that contain leading blanks instead of zeros, optimization was turned off in 10.3.3d for a Select with a Where expression that matches an alpha typed or untyped key. As a result, large Selects may run more slowly. In addition, Join (On) expressions that don't match the ISAM file key type throw an $ERR_INVOPER exception. To avoid these issues, we recommend that you update your ISAM file to include the correct type. However, as a temporary workaround, if you can't immediately make the changes that will permanently correct the situation, you can set SYNSEL_NUMALPHA_KEYS=1 to ignore the key type mismatch check and thus keep your application from slowing down or failing with an %ERR_INVOPER exception.

Warnings about key mismatches are still logged if DBG_SELECT=2 is set.

Setting location

The environment.

Used by

Runtime.

Examples

On Windows,

set SYNSEL_NUMALPHA_KEYS=1