Omit group and struct names from ODBC column names
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
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.
|
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
