Database tab

Use the options on the Database tab to set preferences for handling multi-byte round-trip conversion errors, cascade deletes, and database connections. For Sybase ASE, you also can specify whether to run in Unchained mode.

Example of the Database tab on the Personal Options dialog, described as follows.

Parallel Processing

Maximum Database Connections
Specify the default number of concurrent database connections for an Archive, Delete, or Extract Process. Increasing database connections improves performance when you process large quantities of data by allowing multiple threads to process rows in parallel.

To increase the maximum number of connections, select an even number from 2 through the site maximum as specified in Product Options.

Note: For performance reasons, you can select only an even number of maximum database connections.

MBCS Roundtrip Processing

Options for handling characters that might cause round-trip conversion issues in a multi-byte Optim™ Directory or DB Alias. The availability of these options is governed by the MBCS Roundtrip Processing settings on the Product Options Database tab.

Optim uses the Unicode character set in dialogs and to process data. In some multi-byte character sets (such as Oracle JA16SJIS), multiple characters are mapped to the same Unicode character and might not be converted correctly into Unicode. When these characters are converted from Unicode back to multi-byte (a round trip), the original character might not be returned.

Archive/Extract Requests
Select an option for handling round-trip conversion issues during Archive or Extract processing:
Stop Processing
Stop processing when a multi-byte character is encountered that might cause an incorrect round-trip conversion.
Ignore all round trip Failures
Continue processing when a multi-byte character is encountered that might cause an incorrect round-trip conversion. This option is the default value.
Insert/Load/Convert Requests
Select an option for handling round-trip conversion issues during Insert, Load, or Convert processing:
Stop Processing
Stop processing when a multi-byte character is encountered that might cause an incorrect round-trip conversion.
Ignore all round trip Failures
Continue processing when a multi-byte character is encountered that might cause an incorrect round-trip conversion. This option is the default value.

Select the Ignore all round trip Failures option if the database does not contain data with characters that might cause round-trip errors. You also might select this option if the columns used to manipulate data in a Column Map and the columns for which selection criteria are defined do not contain characters that might cause round-trip errors.

Cascade Delete Rule

Warn On Cascade Delete/Update
Display a warning if a cascading delete or update might occur to a table that is not explicitly included in an Access Definition or a process.
Runtime
Display a cascade delete/update warning only at run time of a process.
Saving Access Definition
Display a cascade delete/update warning only when you are saving the Access Definition.
Always
Display a cascade delete/update warning at run time of a process and when you are saving the Access Definition.
Never
Do not display a cascade delete/update warning. This option is the default setting.

The Warn on Cascade Delete/Update setting in Product Options affects the availability of this option for user input. If available, you can click the down arrow to choose when to display a warning. If unavailable, the value that is specified for Warn on Cascade Delete/Update in Product Options is displayed and cannot be modified. For more information, see the Installation and Configuration Guide.

Sybase Unchained Mode

Run in Unchained Mode
Optim normally runs in chained mode. When a trigger in a Sybase ASE table is fired as a result of an Insert or Delete Process and the trigger calls a stored procedure that must run in unchained mode, the connection also must be in unchained mode.

The Sybase Unchained Mode setting in Product Options enables or disables this check box. If enabled, select the check box to run Insert and Delete Processes in Unchained Mode, or clear the check box to run all actions in normal mode. For more information, see the Installation and Configuration Guide.



Feedback