SYNSEL_NUMALPHA_KEYS

Disable type mismatch processing

WSupported on Windows
USupported on Unix
VSupported on OpenVMS
NSupported in Synergy .NET

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

Any value.

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 do the following:

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

When the file is on OpenVMS, SYNSEL_NUMALPHA_KEYS is set to on by default, since OpenVMS doesn’t support decimal keys.

The environment.

Runtime

On Windows,

set SYNSEL_NUMALPHA_KEYS=1