Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

The mqt select list contains sum where nullable argument


Chapter 7

■■ Predicates with fullselects.

■■ Special registers like CURRENT TIMESTAMP.

■■ GROUPING SETS, CUBE, and ROLLUP are supported. The GROUP BY items and associated GROUPING column functions in the select list must form a unique key of the result set. Thus, the following restrictions must be satisfied:

■■ No grouping sets may be repeated. For example,
ROLLUP(X,Y),X is not allowed because it is equivalent to GROUPING SETS((X,Y),(X),(X)).

■■ If REPLICATED is specified, the table must have a unique key.

■■ When a GROUP BY clause is not specified, the following unique-ness related restriction applies: The materialized view’s non-duplicate requirement is achieved by deriving a unique key for the MQT from one of the unique key constraints defined in each

DB2 Materialized Query Tables 249

■■ MQTs cannot be used as exception tables to collect information when constraints are being validated during bulk constraints check-ing (during LOAD or executing the SET INTEGRITY statement).


How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI1B0F73F
Uploaded by :
Page 1 Preview
the mqt select list contains sum where nullable ar
Sell Your Old Documents & Earn Wallet Balance