SODBC_MCBA

Skip records with MCBA deleted-record characters

WSupported on Windows
USupported on Unix
VSupported on OpenVMS
NSupported in Synergy .NET

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.

Any value.

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.

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

xfODBC

Skipping records with MCBA deleted-record characters

SODBC_MCBA=1