Configure the util utility to recognize different delimiters

During the export process, the util utility reads the fields and records delimiters from the Defaults.rsc configuration file or uses default values, if nothing is defined in Defaults.rsc. The delimiters are stored in the created export file.

During the import process, the util utility reads the delimiter values from the export file and does not refer to the configuration file.

The default values for the records and fields delimiters are as follows:

• \x1E\x1B\x1F - records delimiter
• \x1C\x1B\x1D - fields delimiter

If you are using either of these sequences in your data, add or modify the following lines in the Defaults.rsc file using different values:

namevalue * util_exp_records_delimiter <recordsDelimiter>

namevalue * util_exp_fields_delimiter <fieldsDelimiter>

In the following example, the definitions in Defaults.rsc are set so that the records delimiter is a sequence of vertical tab, horizontal tab, and escape, and the fields delimiter is defined as the form feed character.

namevalue * util_exp_records_delimiter \x0B\t\x1B

namevalue * util_exp_fields_delimiter \f

The following table shows the characters you can use for the records delimiter and fields delimiter, respectively.

The records and fields delimiters must follow these rules:

• a value between 1 and 5 characters.
• The records delimiter must not be a substring of the fields delimiter, and vice versa.
• \0 and blank characters are not valid values. They are not identified and may cause unexpected delimiters to be used.