SODBC_CNVOPT

Ignore “Excluded by ReportWriter” Repository setting

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

The SODBC_CNVOPT environment variable includes all fields in the system catalog, regardless of their “Excluded by ReportWriter” settings in S/DE Repository.

1.

By default, if the “Excluded by ReportWriter” option in Repository is checked for a field, dbcreate does not include the field in the system catalog. To make the field available to ODBC-enabled applications, you can use Repository to clear this option. However, if you want all fields to be included in the generated system catalog, regardless of their “Excluded by ReportWriter” settings, set the SODBC_CNVOPT environment variable.

If a field is used as a structure tag or key segment, it is automatically included in the system catalog, regardless of the report exclusion flag or the SODBC_CNVOPT setting.

The environment where you run dbcreate.

xfODBC

Including and omitting fields

In the environment on Windows,

set SODBC_CNVOPT=1