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 can also specify whether to run in Unchained mode.

personal options database tab, explained below

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 processing 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 only select an even number of maximum database connections.

MBCS Roundtrip Processing

Options for handling characters that could 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 may not be converted correctly into Unicode. When these characters are converted from Unicode back to multi-byte (a round trip), the original character may 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 could cause an incorrect round trip conversion.
Ignore all round trip Failures
Continue processing when a multi-byte character is encountered that could cause an incorrect round trip conversion. (Default.)
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 could cause an incorrect round trip conversion.
Ignore all round trip Failures
Continue processing when a multi-byte character is encountered that could cause an incorrect round trip conversion. (Default.)

Select the Ignore all round trip Failures option if the database does not contain data with characters that could cause round trip errors or if columns used to manipulate data in a Column Map (e.g., a function is used) and columns for which selection criteria are defined do not contain characters that could cause round trip errors.

Cascade Delete Rule

Warn On Cascade Delete/Update
Display a warning if a cascading delete or update may 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 saving the Access Definition.
Always
Display a cascade delete/update warning at run time of a process and when saving the Access Definition.
Never
Do not display a cascade delete/update warning. This 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 specified for Warn on Cascade Delete/Update in Product Options is displayed and cannot be modified. (Refer to 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 will be 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 must be in unchained mode for the procedure to work.

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. (See the Installation and Configuration Guide .)