To configure the data checker

Data Check is available for Oracle enterprise industry models only. It is not supported for SQL Server or for file-based industry models.

1. In the Infrastructure Administrator, do one of the following:
   • Click Enterprise and connect to the enterprise industry model. Open a project.
   • Click File and open an industry model drawing or template.
2. Click the Industry Model node.
3. Click Industry Model menu > Data Checker.
4. Under Data Checker, click the General tab and click to create a check.
5. Enter a name and, optionally, a parent check and a description.
6. Specify the SQL select statement that will be executed by the selected data check.

   A check statement is an SQL select statement that analyzes the data and returns errors. If the check statement does not return any rows, the data is valid. Use the SQL Assistant to compose your statement. See SQL Expression Reference.

   The SQL select statement must return a set of FIDs, and should match the following skeletons.

   • For simple data checks, use

     SELECT fid FROM <feature class> WHERE <checking condition> ORDER BY fid;

   • For advanced data checks, use

     REPEAT <select statement> FOR <select statement>;

     This SQL select statement repeats the first select statement as long as the second select statement returns a result.

     In the first <select statement> you can use placeholders that represent columns of the second <select statement>. For example:

     REPEAT
     SELECT fid from $f_class_name WHERE <checking condition>
     FOR
     SELECT f_class_name from TB_DICTIONARY where f_class_name like 'EL%';

     Note: Define any database view to perform the check, and use the Check statement to execute a SELECT on this view. For example:

     SELECT fid FROM <database view> ORDER BY fid;

7. Click Check SQL to validate your statement.
8. Set any of the following advanced options:

   Module Name	If you define data checks to be used by a customized plug-in, use the Module Name value to filter the data checks that are executed. For example, use this option to use the Data Checker through the API.
   Row Level Security	Specifies the row level security
   Data Check Applies To The Selected Job Or To The Live Job (For Scheduled Tasks)	Execute the data check in the current job (in case of manual start) or in the live job (in case of scheduled start).
   Data Check Applies To The Entire Enterprise Industry Model	Execute the data check in the entire enterprise industry model.