SODBC_MCBA

Skip records with MCBA deleted‑record characters

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

The SODBC_MCBA environment variable instructs xfODBC to skip records that contain the MCBA deleted‑record characters, which are four right brackets (]]]]) at the beginning or end of a record.

Value

Any value.

Discussion

By default, SODBC_MCBA is not set; xfODBC does not skip records that contain the MCBA deleted‑record characters. To instruct xfODBC to skip records that contain the MCBA deleted‑record characters, set the SODBC_MCBA environment variable to any value.

SODBC_MCBA is used by the xfODBC driver when it accesses data. It is not used when you create or modify a system catalog.

Setting location

The connect file, the current environment, or the system‑level. For client/server configurations, set SODBC_MCBA in the connect file on the server.

Used by

xfODBC.

See also

Recognizing the MCBA deleted-record characters.

Examples

SODBC_MCBA=1