Data validation


Data Validation enables you to validate data based on data type or the actual values within the record. You may specify the valid values for a field online or in an external file. Validation processes include alpha, alphanumeric, and numeric data checking. When invalid data is found in any of the fields of a record, a return code of 04 is set indicating that not all data was valid.

Specify the following information to create formatted data validation criteria:

  • Specify the TA (table) or LI (list) relational operator (RO) to the right of the field for which you want to create data validation criteria.
  • File-AID/Data Solutions displays a Criteria pop-up window based on the relational operator (RO) that you specified. Enter the appropriate parameters.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX File-AID/Data Solutions 23.01