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.


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.)

The environment where you run dbcreate.


Renaming columns for clarity (SODBC_ODBCNAME)

In the environment on Windows,