Neoview Workload Management Services Guide (R2.4)

STATUS RULE COMP Command
The STATUS RULE COMP command returns information about all the compilation rules.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
STATUS RULE COMP
Considerations
• The STATUS RULE COMP command returns this status information:
Table A-18 STATUS RULE COMP Output
DescriptionData TypeColumn Name
COMPVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)NAME
AND, ORVARCHAR(3)OPER
Relative priority of the expression to other expressions in
the rule
INTEXPR_PRTY
External form of the rule expressionVARCHAR(128)EXPR
LOW, MEDIUM, HIGH, NO-WARNVARCHAR(8)WARN_LEVEL
HOLD, REJECT, or the SQL string to executeVARCHAR(1024)ACT
Comment stringVARCHAR(256)COMMENT
Examples
• This command displays the statistics for all compilation rules:
STATUS RULE COMP;
STATUS RULE COMP Command 139