Ignore “Excluded by ReportWriter” Repository setting
|
WSupported on Windows
|
USupported on Unix
|
VSupported on OpenVMS
|
NSupported in Synergy .NET
|
The SODBC_CNVOPT environment variable includes all fields in the system catalog, regardless of their “Excluded by ReportWriter” settings in S/DE Repository.
Value
1
Discussion
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.
Setting location
The environment where you run dbcreate.
Used by
xfODBC
See also
Examples
In the environment on Windows,
set SODBC_CNVOPT=1
