Download IBM Optim: Optim Installation and Configuration Guide

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. 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 (see “Cascade Delete Rule” on page 223)
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.
Chapter 9. Personal Options
287