SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-28
Enabling the Similarity Check for Tables and
Protection Views
•
Any of these file attributes:
•
Statistics on the tables
•
Column headings
•
Comments on columns, constraints, collations, indexes, or tables
•
Catalog where the table is registered
•
Help text
•
Number of columns. RUN-TIME-TABLE can have more columns than
COMPILE-TIME-TABLE, but the common columns of both tables must have
identical attributes. However, if a statement uses a SELECT list containing an
asterisk (*), RUN-TIME-TABLE must have the same number of columns as
COMPILE-TIME-TABLE. For more information, see the following subsections.
For more information about similarity, see the SQL/MP programming manual for your
host language.
Similarity Rules for Protection Views
The similarity check does not support shorthand views; similarity rules for protection
views are:
•
A protection view is never similar to a table or any other object.
•
To pass the similarity check, two protection views must follow these criteria:
°
Have similar underlying base tables
°
Project the same columns from the base tables
°
Have the same column names
°
Have the same selection expression, which is determined by a binary
comparison of the generated objects for the two selection expressions
ALLOCATE LOCKLENGTH SECURE
AUDITCOMPRESS MAXEXTENTS SERIALWRITES
BUFFERED NOPURGEUNTIL TABLECODE
CLEARONPURGE OWNER VERIFIEDWRITES
EXTENT (primary and secondary)
Note. The similarity check does not apply to parallel execution plans. Tables are not
considered similar if they are specified in a query that uses a parallel execution plan.