Use decimal information in format string

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

The SODBC_USEFORMAT environment variable instructs dbcreate to generate implied‑decimal system catalog columns from repository fields with format strings that include decimal points.




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


See also

Using decimal information in the repository format string (SODBC_USEFORMAT).


In the environment on Windows,