ROWDELIMITER
ROWDELIMITER is a required configuration parameter that specifies which character to use for delimiting rows.
Description
You specify ROWDELIMITER when you want InfoSphere Classic CDC for z/OS to publish changes in a delimited format.
Specify the value as a hexadecimal number or enclose the value in single quotation marks.
Specifications
Specifying delimited messages describes the rules that apply to defining a delimiter.
In general, delimiter
values should be enclosed in single quotes.
- If you use character delimiters and would like to preserve the case you need to enclose the value with single quotes or it will be converted into uppercase. Use of delimiters that contain letters or numbers is not recommended.
- If the delimiter value contains a single quote, you can enclose the value in double quotes.
- If the delimiter value contains a double quote, you can enclose the value in single quotes.
- You cannot define a delimiter string with a mixture of single and double quotes.
- The following escape characters can be specified in single quotes:
\r – carriage return, equivalent to 0X0D
\n – new line character, equivalent to 0X15
\f – form feed, equivalent to 0X0C
\t – tab, equivalent to 0X05
\v – vertical tab, equivalent to 0X0B
- To specify an unsupported escape character, you can enter the hexadecimal representation of the value. You must define hexadecimal values with the prefix "0X". Inclusion of a null character (0x00) in the delimiter value will lead to unpredictable results.
Use: Configuration parameter for the capture service.
Service class: CAP
Service task name: CECCAP
Data type: CHAR(8)
Default: \n (new line character)