Professional > Data management scripting > Transferring data using a DMS file > Writing data > Validation options when transferring data
 
Validation options when transferring data
There are some validation options that you can set when you use the UNICOM Intelligence Data Model to write the output case data. The actual validation that takes place varies according to the CDSC that is being used to write the case data. However, you set the options in the same way. This topic explains the validation options and how to set them.
You define the validation options in the connection string in the OutputDataSource section. If you are using the Connection String Builder or the WinDMSRun sample application to set up the connection string, you can select the validation options on the Advanced tab in the Data Link Properties dialog box.
If you do not specify otherwise, validation in clean mode is automatically selected. When validation is selected (whether in clean or dirty mode) and a record fails the validation, by default, both UNICOM Intelligence Professional and DMS Runner display an error message showing the record number and continue with the run. If the DMS file has a Logging section, the bad record is written to the log file. At the end of the run, the total number of “bad” records that were encountered is shown. (A “bad” record is a record that fails the validation.) However, you can make DMS Runner stop when it encounters a record that fails the validation. You do this using the DMS Runner /break option when you run the file.
No validation
When you select this option, the CDSC performs no validation of the data at all. However, some problems can cause errors and prevent the export from succeeding. You select this option as follows:
If you are setting up the connection string using the Data Link Properties dialog box, on the Advanced tab deselect Perform data validation.
If you are setting up the connection string manually, set the MR Init Validation connection property to False:
MR Init Validation=False;
Validation in clean mode
The CDSC validates the case data and rejects incorrect and inconsistent data. You select this option as follows:
If you are setting up the connection string using the Data Link Properties dialog box, on the Advanced tab select Perform data validation and deselect Allow dirty.
If you are setting up the connection string manually, set the MR Init Allow Dirty property to False and the and the MR Init Validation property to True:
MR Init Allow Dirty=False; MR Init Validation=True;
Validation in dirty mode
The CDSC performs validation checks but accepts some incorrect and inconsistent data, generally issuing a warning when it does so. You select this option as follows:
If you are setting up the connection string using the Data Link Properties dialog box, on the Advanced tab select Perform data validation and Allow dirty.
If you are setting up the connection string manually, set the MR Init Allow Dirty and MR Init Validation properties to True:
... MR Init Allow Dirty=True; _
    MR Init Validation=True; ...
See also
Transferring data using a DMS file
OutputDataSource section
WinDMSRun
Writing data