If enabled, you can override all of the flag-type settings within the "Other Options" section of the Data Source Options panel. This allows you to establish Data-Source-specific settings for these options.
Specifies that the ODBC driver caches table lists returned by the SQLTables function. This option improves performance by reducing the amount of time it takes to retrieve a list of tables, but does not always provide the most current view of existing tables. When selected, the ODBC driver uses the cached result to process repeated SQLTables requests. The ODBC driver flushes the cache whenever you turn off this option, change the request parameters, change the name of the Accessible Tables view, or disconnect from a session.
Enables the ENSURE parameter of the ODBC SQLStatistics function.
The ENSURE parameter of the SQLStatistics function call usually causes the ODBC driver to issue an UPDATE STATISTICS command to CA IDMS SQL against the named table. For large tables, this can cause deadlocks or communication timeout errors. The default, disabling the Ensure option, is recommended unless a specific application requires otherwise.
Forces the ODBC driver to return single precision floating point numbers as double precision to avoid the rounding that can occur when numbers are passed from the mainframe to the PC.
Note: Some loss of precision is unavoidable when converting between the floating point formats, because different numbers of bits are used to encode the exponent and mantissa.
Causes the SQLDriverConnect function to display a dialog if the optional Account parameter is not passed on the connection string.
When enabled, you can enter the name of a view to use for the ODBC SQLTables function and JDBC getTables method, instead of using the catalog tables directly. Use this field to specify the default view, SYSCA.ACCESSIBLE_TABLES, or define a different view in the catalog and enter it in this field.
When a catalog contains a large number of table definitions, performance can be improved by specifying a view name, to create a tailored view of the tables of interest to the end user. For example, the SYSCA.ACCESSIBLE_TABLES view returns only those tables to which the user has Select authority. You can also limit tables based on schema or authorization. In addition, this feature is useful when security requirements do not allow direct access to the catalog tables.
If you specify a different name, be sure that it contains at least the same columns as SYSCA.ACCESSIBLE_TABLES, although it can contain additional columns.
The view definition must include the following columns:
Click Apply or OK to save changes to the defaults in the registry. Click Cancel to close the dialog without saving any new changes.
Note: For more information about the SYSCA.ACCESSIBLE_TABLES view, see the CA IDMS Database SQL Option Reference Guide.
|
Copyright © 2009 CA.
All rights reserved.
|
|