Partitionings, if any, appear last on the report. The classifying attribute follows the words PARTITIONED BY. Under the classifying attribute, columns appear for its classifying values, if any, and for the entity subtypes that belong to the partitioning.
For example, in the following illustration the entity type EMPLOYEE is partitioned by the classifying attribute TYPE and includes two classifying values, EXEMPT and NONEXEMPT. The partitioning also includes two entity subtypes, EXEMPT_STAFF and NONEXEMPT_STAFF.
PARTITIONED BY: TYPE CLASSIFYING VALUE SUBTYPE ----------------- ------- EXEMPT EXEMPT_STAFF NONEXEMPT_STAFF
|
Copyright © 2013 CA.
All rights reserved.
|
|