SODBC_NOGROUPNAME

Omit group and struct names from ODBC column names

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

The SODBC_NOGROUPNAME environment variable causes group and struct field names to be omitted from column names in the system catalog.

Value

Any value.

Discussion

By default, if a field is part of a group or struct field in the repository, the group or struct field name is added as a prefix to the field name to create the column name in the system catalog. Setting SODBC_NOGROUPNAME to any value supersedes this default.

Important

Set SODBC_NOGROUPNAME only if you are certain the resulting column names will be unique.

If you’re going to set this variable, make sure you do so before generating your system catalog.

Setting location

The environment where you run dbcreate.

Used by

xfODBC.

See also

Removing group and struct names from column names (SODBC_NOGROUPNAME).

Examples

In the environment on Windows,

set SODBC_NOGROUPNAME=1