Table Rules Also Exclude Records

Another way to exclude records from being archived or purged is to set up table rules on a DB process instruction. A table rule's override condition is incorporated into the WHERE clause in the SQL statement that builds the subset of production data for archive or purge when the Archive Engine runs. Table rules may be specified on any DB process instruction for any table within that DB process instruction, but are generally specified only on a Primary DB process instruction's Primary table.

Imagine a table rule specified on the Primary DB process instruction for an "Archive Bill" DB process as follows: #CI_BILL.ACCT_ID <> '2846738204'. Specifying this table rule prevents the Archive Engine from archiving any bills for account 2846738204.

CAUTION:

Table rules are usually not used with archive or purge DB processes. Specifying additional WHERE clauses may introduce inefficient data access. Only consider using a table rule if an index supports the WHERE clause.

Note: Inner Joins. If you specify a table rule on a Child table within the DB process instruction, that table is joined with its recursive parent tables in the resulting SQL. Use the SQL viewer to make sure that the resulting SQL is really what you want.

Fastpath: Refer to Defining Database Process Instruction Options for more information on setting up DB process instruction table rules.