checks
Enable or disable testing for the existence of tables and stored procedures.
USYS$Mnemonic_PARAMS =
checks : enabled | disabled
USYS$Mnemonic_PARAMS =
checks : on | off
Use
| Applies to | Mnemonic | Connector Syntax |
|---|---|---|
| DB2 connector | DB2 | USYS$DB2_PARAMS
|
| MySQL connector | MQL | USYS$MQL_PARAMS
|
| MS SQL connector | MSS | USYS$MSS_PARAMS
|
| ODBC connector | ODx | USYS$ODx_PARAM
|
Description
This option controls whether an existence check on
a table is performed before accessing it. It is intended for performance enhancement in a
production environment. If not specified, this option defaults to on
(enabled).
Caution: Be careful when using this option. If these checks are disabled, Uniface assumes that the tables and stored procedures are present. If this is not the case, Uniface is left in an undetermined state.
