SYSTEM.RULECOLUMN records the columns listed for the UPDATE statement
type in the rule.
Initially, the table is empty, since the system catalog does not use
rules. ALLBASE/SQL updates the table when processing a CREATE RULE,
DROP RULE, or TRANSFER OWNERSHIP involving a rule.
RULENAME and OWNER uniquely identify a particular rule. The table it
is defined upon may be deduced by searching the SYSTEM.RULE table
for a match on these two columns. The SYSTEM.RULE view contains the
TABLENAME.
Table 8-29 System.RuleColumn
| Column Name | Type | Length | Description |
|---|
| RULENAME | CHAR | 20 | Name of the rule |
| OWNER | CHAR | 20 | Owner of the rule |
| COLUMNNAME | CHAR | 20 | Name of the column
for which an UPDATE results in firing the rule
|
Example |
 |
select * from system.rulecolumn;
--------------------+--------------------+--------------------
RULENAME |OWNER |COLUMNNAME
--------------------+--------------------+--------------------
UPDATEREPORT |PURCHDB |REPORTOWNER
UPDATEREPORT |PURCHDB |ReportName
---------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] >
|
