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 (?).

Enable High Value Padding

This option lets you mark items as padded with high values in order to achieve left justification. It applies to ALPHA items and unsigned numeric items that are store as ALPHA data.

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.

Discard record thresholds

Set these values to control how the Client handles discarded records.

Maximum total discards is the total number of discards the Client will tolerate before abending. This value must be greater than the value for Maximum per-table discards unless the second value is zero, indicating that it's unlimited.

Maximum per-table discards is the maximum number of discards records for a table that are written to the discard file. Discards that exceed this number are ignored. If either of these values are set to zero, no limits are imposed for the corresponding actions, and the Client will behave the way it did before this parameter was implemented.