Use decimal information in format string
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The SODBC_USEFORMAT environment variable instructs dbcreate to generate implied-decimal system catalog columns from repository fields with format strings that include decimal points.
Value
1
Discussion
If your repository has a field that is not an implied decimal but that has a format string with a decimal point, you can instruct dbcreate to use the decimal information in the format string to create an implied-decimal column in the system catalog. To do this, set the SODBC_USEFORMAT environment variable to 1 before generating the system catalog. For example, if SODBC_USEFORMAT is set to 1 and your repository has a d5 field with an XXX.XX format string, the field will appear as a d5.2 column in the system catalog.
Setting location
The environment where you run dbcreate.
Used by
xfODBC
See also
Using decimal information in the repository format string (SODBC_USEFORMAT)
Examples
In the environment on Windows,
set SODBC_USEFORMAT=1
