Locate Selects that cause a specific problem
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The DBG_SELECT_INTERNAL environment variable forces an exception on the specified condition.
Value
One of the following:
64 = Find Selects that don’t optimize due to key type mismatch.
128 = Find Selects that optimize to a secondary key because of a primary key type mismatch.
Discussion
DBG_SELECT_INTERNAL affects the behavior of DBG_SELECT, to aid in the debugging of a type mismatch. When DBG_SELECT_INTERNAL is set to 64, a type mismatch during the Select that would cause optimization to be disabled will instead throw an $ERR_INVOPER exception that can be used to locate the situation. Setting DBG_SELECT_INTERNAL to 128 causes the exception to be thrown on a mismatch even when optimization still occurs due to a secondary key. These options can be set regardless of the setting of DBG_SELECT.
Setting location
The environment.
Used by
Runtime
See also
DBG_SELECT environment variable
Examples
On Windows,
set DBG_SELECT_INTERNAL=64
