Use Repository “Alternate name” field
|
WTSupported in traditional Synergy on Windows
|
WNSupported in Synergy .NET on Windows
|
USupported on UNIX
|
VSupported on OpenVMS
|
The SODBC_ODBCNAME environment variable causes xfODBC to use the values in the Repository “Alternate name” field as column names.
Value
1
Discussion
Not all Repository field names make good ODBC column names. As an alternative, you can use the value in the Repository “Alternate name” field (if one is specified) as the column name by setting the SODBC_ODBCNAME environment variable.
(Note that this is not related to the Repository ODBC table name option, which enables you to assign ODBC table names to file/structure combinations.)
Setting location
The environment where you run dbcreate.
Used by
xfODBC
See also
Renaming columns for clarity (SODBC_ODBCNAME)
Examples
In the environment on Windows,
set SODBC_ODBCNAME=1
