DMSII Data Error Handling

Specify processing settings for the selected data source. Configuration file parameters are provided in parentheses.

Character data error

Control character

Change to space (convert_ctrl_char)

Changes a control character encountered in alpha data to a space.

Change to '?' and count as error (inhibit_ctrl_chars)

Treats a control character encountered in alpha data as an error and converts it to a question mark (?).

Translate if possible

Translates control characters that do not interfere with client operations. The client won't allow a control character to be translated to the character NULL (00) as this causes problems with NULL terminated strings. In addition, it won't allow the use of CF and LF characters, as they interfere with bulk-loader operations. If you use SQL Server and the tab character is the bcp delimiter, the client won't allow you to translate a character to a tab character.

Change 8-bit character to '?' and count as error (inhibit_ctrl_chars)

Considers each 8-bit character in alpha data to be an error and converts it to a question mark (?).

Set item to NULL if errors exceed (%) (alpha_error_cutoff)

Specifies the percentage of data errors in any given alpha item that is tolerated before the field is declared bad and is treated as NULL.

General error handling

Discard records containing data errors (discard_data_errors)

Instructs the Client to write all records with data errors to the discard file tablename.bad and not apply them to the relational database.

Display data errors (in log file) (display_bad_data)

Causes the DATABridge Client to display the raw DMSII data for an item that has a data error. Use this option for debugging if you encounter many data errors. Typically, this output is suppressed when the number of errors exceeds the limit specified by Error display limit.

Suppress duplicate (insert) warnings (suppress_dup_warnings)

Prevents warnings for duplicate inserts and failed updates from displaying during update processing.

Error display limits (error_display_limits)

Set the maximum number of errors per data set that is permitted on-screen (display) and saved in the log file.