ReplaceStrList

Specifies one or more substitution sets, each composed of an individual character to be replaced, a character delimiter, and a substitution string. The connector performs this substitution on an attribute's value only if a value has been specified for the [ESC=true|false] parameter of the attribute's AppSpecificInfo property or for the connector's ReplaceAllStr property.

Note:
The ESC parameter and the ReplaceAllStr and ReplaceStrList properties provide support for database escape character functionality (for example, to escape single quotation marks).

The syntax for this attribute is:

single_char1,substitution_str1[:single_char2,substitution_str2[:...]]

where:

single_char
A character to be replaced.

substitution_str
The substitution string that the connector uses to replace the character.

,
The character delimiter, which separates the character to be replaced from the string that replaces it. By default, the character delimiter is a comma (,). You can configure this delimiter by setting the first delimiter in theStrDelimiter property.

:
The termination delimiter, which separates substitution sets (each of which is composed of the character to be replaced, a character delimiter, and the substitution string). By default, the termination delimiter is a colon (:). You can configure this delimiter by setting the second delimiter in the StrDelimiter property.

For example, assume you want to replace a single percent sign (%) with two percent signs (%%), and a caret (^) with a backslash and a caret (\^). By default, StrDelimiter specifies a comma (,) as the character delimiter, and a colon (:) as the termination delimiter. If you keep the default delimiters, use the following string as the value of ReplaceStrList:

%,%%:^,\^

Note:
A restriction of the connector configuration tool prevents entering single quotation marks. Therefore, you must represent a single quotation with the character Q, and two single quotations with the characters DSQ. In the above example, if you also want to substitute a single quotation mark (') with two single quotation marks (''), use the following notation: Q,DSQ:%,%%:^,\^

Default value: Q,DSQ .

Note:
In the connector configuration tool, these characters represent a single quotation mark, followed by a comma, followed by two single quotation marks.

Possible values: A set composed of a single character, a character delimiter, and the character's substitution string. Also, multiple such sets with a termination delimiter between them.

Required: No

Copyright IBM Corp. 1997, 2004