disable checks

Description

When accessing a table, Uniface first checks that the table exists, and then calls the PACKAGE_VERSION procedure in the stored package associated with the table. Uniface then checks whether the major package version of that package is compatible with the current major package version of the ORA connector, and stores the minor package version in its internal administration.

When disable checks is set, Uniface:

• Performs a simplified table existence check by parsing the following SELECT query:

  SELECT 0 FROM TableName

  This is more efficient than the default query, which is used to gather information required for the storage format and Unicode field checks :

  SELECT FieldName1, FieldName2, ... FROM TableName

• Skips the PACKAGE_VERSION procedure. You must therefore ensure that both the major package version and the minor package version are identical to the current major and minor package versions of the ORA connector.

Setting disable checks may improve performance. However:

• If either the major or minor package version is not identical to the current package version of the ORA connector, obscure errors can occur at run time. To avoid this problem, follow the package upgrade procedure before setting the disable checks option.
• If your Oracle database is Unicode-enabled, in some circumstances (for example, when fields with W packing codes are mapped to CHAR storage formats), it can result in degraded performance because extra data conversions are performed. In this case, you should not use this setting.

  For more information, see Table Existence Checks.

Note:  It is recommended that whenever you install a new release of Uniface or the ORA connector, you first test your applications and databases without the disable checks option set.