SODBC_NONULL

Set “Null allowed” property for system catalog columns

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

This environment variable is deprecated. We recommend setting the “Null allowed” Repository option to Yes or No for each field. See Preventing null updates and interpreting spaces, zeros, and null values.

The SODBC_NONULL environment variable setting determines how the “Null allowed” property is set in the system catalog for repository fields where the “Null allowed” Repository value is Default (rather than Yes or No).

Value

One of the following values:

0

Set all columns to “null allowed.”

1

Set only date columns that aren’t part of the definition for the first key to “null allowed.” (This was the only supported behavior prior to Connectivity Series 9.3.)

2

Set all columns to “null allowed” except those that are part of the first key definition.

3

Set all columns to “null allowed” except those that are part of an access key.

4

Set all columns to “null allowed” except integer, binary, Boolean, and non‑date columns that are part of the first key definition.

Discussion

By default, SODBC_NONULL is not set, which is the equivalent of setting it to 4. If you set this environment variable, set it before you generate the system catalog. Note the following:

Setting location

The environment where you run dbcreate.

Used by

xfODBC.

See also

Preventing null updates and interpreting spaces, zeros, and null values.

Examples

In the environment on Windows,

set SODBC_NONULL=4