Figure 5.3 gives a view of all the
parameters that needed to pass to the add_table_rules
procedure to create the Apply process. The procedure has two OUT
variables, dml_rule_name and ddl_rule_name, to
show the rules that are generated. The streams_type
parameter needs to be specified as APPLY.
Figure 5.3 add_table_rules procedure
In the add_table_rules procedure,
various parameters provide necessary attributes as shown below:
include_dml: If TRUE,
the procedure creates a DML rule for DML changes. If FALSE, the
procedure does not create a DML rule. NULL is not permitted.
include_ddl: If TRUE,
the procedure creates a DDL rule for DDL changes. If FALSE, the
procedure does not create a DDL rule. NULL is not permitted.
TRUE, no condition regarding Streams tags is added to the
generated rules. Therefore, these rules can evaluate to TRUE
regardless of whether a redo entry or LCR has a non-NULL tag.
inclusion_rule: If inclusion_rule is TRUE, the rules are added to the positive
rule set for the Streams client. If inclusion_rule is
FALSE, the rules are added to the negative rule set for the
The following example will be used to
illustrate the Apply creation process. The following SQL
statement creates an Apply process named ln1_apply and
defines rules for the table NY1.ALLINSURED1:
Creating Apply Side Table rules at Destination(DNYOIP20)