Ignore the “Negative allowed” Repository setting
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The SODBC_NOUNSIGNED environment variable instructs dbcreate to ignore “Negative allowed” Repository settings for fields when creating the system catalog.
Value
Any value.
Discussion
By default, SODBC_NOUNSIGNED is not set; dbcreate checks the “Negative allowed” Repository setting to determine if the resulting column will be signed or unsigned.
If you set SODBC_NOUNSIGNED to any value, dbcreate sets all numeric fields to signed unless they have validation ranges that are limited to positive values (in which case the resulting columns will be unsigned). This matches the behavior for Connectivity Series versions prior to 8.3.
If you set this environment variable, set it before generating your system catalog.
Setting location
The environment where you run dbcreate.
Used by
xfODBC
See also
Instructing dbcreate to ignore Repository’s “Negative allowed” field (SODBC_NOUNSIGNED)
Examples
In the environment on Windows,
set SODBC_NOUNSIGNED=1
