Disable blank to zero conversion on lookup key
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The SYNSEL_NUMALPHA_CONVERT environment variable disables the automatic conversion of leading blanks to zeros on lookup keys in Synergy/DE 11.1.1i and higher.
Value
One of the following:
0 = Disable the “ ” to “0” conversion on lookup keys. (default on Windows and Unix)
1 = Enable the “ ” to “0” conversion on lookup keys. (default on OpenVMS)
Discussion
Because decimal keys cannot be used on OpenVMS, a mismatch between a decimal join expression and the inner table join key can occur. This causes leading blanks to be converted to zeros on the lookup key, as it is common on OpenVMS for a decimal key value to have leading zeros rather than leading blanks. To disable this behavior, you can set SYNSEL_NUMALPHA_CONVERT=0.
On Windows and Unix, SYNSEL_NUMALPHA_CONVERT is set to 0 by default.
Setting location
The environment.
Used by
Runtime
Examples
On OpenVMS,
$ DEFINE SYNSEL_NUMALPHA_CONVERT 0
