Open topic with navigation
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.
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.