Number of errors that may occur before validation procedure is aborted. When -1 the procedure does not terminate due to an error. (shipped with: -1 → no limit)

Number of messages/errors that are logged by the feature. (shipped with: -1 → log all)

Number of records that should be validated. (shipped with: -1 → validate all)

Number of records retrieved by a single database access. The higher this value the less database accesses needed, but the more memory is used. (shipped with: 10000)

Flag to toggle generation of default order by clause.

• true → ORDER BY clause based on primary key is generated
• false → no ORDER BY clause is generated

Default direction of order by clause if USE_DEFAULT_PK_ORDER_BY is on.

• ASC → ascending order
• DESC → descending order

String + pattern for alias clause for editing tables when catalog object join is used

• “” (blank) → no alias
• “a” → the alias is the given character or string
• “abc%cat_id%” → the alias is the given character or string concatenated with the actual catalog ID.

// validation feature settings
 define('MAXNUMBER_VALIDATIONERR', -1);
 define('MAXNUMBER_VALIDATIONMSG', -1);
 define('MAXNUMBER_VALIDATIONROW', -1);
 define('VALIDATION_CHUNK_SIZE', 10000);

// SQL generation settings
 define('USE_DEFAULT_PK_ORDER_BY', true);
 define('DEFAULT_GRID_ORDER_BY', 'ASC');
 define('SYSTEM_OBJECT_ALIAS_GRID', 'a%cat_id%');