Predicate Analysis Rules Abbreviations
List of Abbreviations
This appendix contains a complete list of the abbreviations used in the short and long messages you may receive when using Predicate Analysis.
Abbreviations Used in Rule Recommendations
Abbreviation | Explanation |
|---|---|
LHS | left-hand side of a predicate |
RHS | right-hand side of a predicate |
RHS2 | the second operand on the right-hand side of a predicate such as column C in the predicate A between B and C or A like B escape C. |
col | column |
hostvar, hv | host variable |
expr | expression |
IntegerArithmeticConstant | arithmetic expression that contains only integer constants - for example, 10*5*2 |
op | operator - often, this operator is restricted to an arithmetic operator. The detailed message has more information about any restrictions. |
intConst | integer constant |
colExpr | expression that includes columns - for example, A*10+2.0 |
noncolexpr, | expression that does not include columns - for example, 10*2.0 |
(...) | an IN list |
noncorr_subq | noncorrelated subquery |
corr_subq | correlated subquery |
quantifiers | ALL, ANY, SOME, or DISTINCT |
(C1,C2,..Cn) | A list of columns for Db2. |