Class LUWTable {Analysis} derived from: DB2TableLUWStorageTable

Documentation
DB2 Universal Database SQL Reference Version 8.1 (Vol.1 and 2)
http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html

Tables

Tables are logical structures maintained by the database manager. Tables are made up of columns and rows. The rows are not necessarily ordered within a table (order is determined by the application program). At the intersection of every column and row is a specific data item called a value. A column is a set of values of the same type or one of its subtypes. A row is a sequence of values arranged so that the nth value is a value of the nth column of the table.

A base table is created with the CREATE TABLE statement and is used to hold persistent user data. A result table is a set of rows that the database manager selects or generates from one or more base tables to satisfy a query.

A summary table is a table defined by a query that is also used to determine the data in the table. Summary tables can be used to improve the performance of queries. If the database manager determines that a portion of a query can be resolved using a summary table, the database manager can rewrite the query to use the summary table. This decision is based on database configuration settings, such as the CURRENT REFRESH AGE and the CURRENT QUERY OPTIMIZATION special registers.

A table can define the data type of each column separately, or base the types on the attributes of a user-defined structured type. This is called a typed table. A user-defined structured type may be part of a type hierarchy. A subtype inherits attributes from its supertype. Similarly, a typed table can be part of a table hierarchy. A subtable inherits columns from its supertable. Note that the term subtype applies to a user-defined structured type and all user-defined structured types that are below it in the type hierarchy. A proper subtype of a structured type T is a structured type below T in the type hierarchy. Similarly, the term subtable applies to a typed table and all typed tables that are below it in the table hierarchy. A proper subtable of a table T is a table below T in the table hierarchy.

A declared temporary table is created with a DECLARE GLOBAL TEMPORARY TABLE statement and is used to hold temporary data on behalf of a single application. This table is dropped implicitly when the application disconnects from the database.


Parent PackageLUWAbstractNo
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Operations
NameSignatureClass
getUniqueConstraintsList getUniqueConstraints ()BaseTable
getForeignKeysList getForeignKeys ()BaseTable
getPrimaryKeyPrimaryKey getPrimaryKey ()BaseTable
addEAnnotationEAnnotation addEAnnotation (String source)SQLObject
addEAnnotationDetailvoid addEAnnotationDetail (EAnnotation eAnnotation, String key, String value)SQLObject
getEAnnotationDetailString getEAnnotationDetail (EAnnotation eAnnotation, String key)SQLObject
setAnnotationDetailvoid setAnnotationDetail (EAnnotation eAnnotation, String key, String value)SQLObject
removeEAnnotationDetailvoid removeEAnnotationDetail (EAnnotation eAnnotation, String key)SQLObject
getEAnnotationEAnnotation getEAnnotation (String source)SQLObject
getEAnnotationEAnnotation getEAnnotation (String source)EModelElement
eClassEClass eClass ()EObject
eIsProxyboolean eIsProxy ()EObject
eResourceEResource eResource ()EObject
eContainerEObject eContainer ()EObject
eContainingFeatureEStructuralFeature eContainingFeature ()EObject
eContainmentFeatureEReference eContainmentFeature ()EObject
eContentsEEList eContents ()EObject
eAllContentsETreeIterator eAllContents ()EObject
eCrossReferencesEEList eCrossReferences ()EObject
eGetEJavaObject eGet (EStructuralFeature feature)EObject
eGetEJavaObject eGet (EStructuralFeature feature, boolean resolve)EObject
eSet eSet (EStructuralFeature feature, EJavaObject newValue)EObject
eIsSetboolean eIsSet (EStructuralFeature feature)EObject
eUnset eUnset (EStructuralFeature feature)EObject
getTableSpacesList getTableSpaces ()LUWStorageTable


Attributes
NameClassTypeInitial Value
PCTFreeLUWTableint 
restrictOnDropLUWTableboolean 
partitionModeLUWTableString 
appendModeLUWTableboolean 
logModeLUWTableString 
lockSizeRowLUWTableboolean 
volatileLUWTableboolean 
dataCaptureDB2TableDataCaptureType 
selfRefColumnGenerationTableReferenceType 
insertableTableboolean 
updatableTableboolean 
descriptionSQLObjectString 
labelSQLObjectString 
nameENamedElementString 
valueCompressionLUWStorageTableboolean 
rowCompressionLUWStorageTableboolean 


Associations
NameMy RoleMy ClassOther RoleOther Element
--Not Named----Not Named--LUWTableoptionsLUWOption
--Not Named----Not Named--DB2TablepackagesDB2Package
--Not Named----Not Named--BaseTableconstraintsTableConstraint
--Not Named--constrainedTablesBaseTable--Not Named--Assertion
--Not Named--referencedTableBaseTablereferencingForeignKeysForeignKey
--Not Named--tableBaseTable--Not Named--RelationalRemoteDataSet
--Not Named--supertableTablesubtablesTable
--Not Named--tableTablecolumnsColumn
--Not Named----Not Named--TableudtStructuredUserDefinedType
--Not Named--subjectTableTabletriggersTrigger
--Not Named--tablesTableschemaSchema
--Not Named--tableTableindexIndex
--Not Named--scopeTableTable--Not Named--ReferenceDataType
--Not Named--aliasedTableTable--Not Named--DB2Alias
--Not Named--synonymedTableTable--Not Named--zSeriesSynonym
--Not Named----Not Named--SQLObjectcommentsComment
=--Not Named--SQLObjectdependenciesDependency
--Not Named--objectSQLObjectprivilegesPrivilege
--Not Named--actionObjectsSQLObject--Not Named--Privilege
--Not Named--eModelElementEModelElementeAnnotationsEAnnotation
--Not Named--contentsEObject--Not Named--EAnnotation
--Not Named--referencesEObject--Not Named--EAnnotation
--Not Named--targetEndEObject--Not Named--Dependency
--Not Named--tableLUWStorageTablepartitionKeyLUWPartitionKey
--Not Named--indexDataTablesLUWStorageTableindexDataTableSpaceLUWTableSpace
--Not Named--LOBDataTablesLUWStorageTableLOBDataTableSpaceLUWTableSpace
--Not Named--regularDataTablesLUWStorageTableregularDataTableSpaceLUWTableSpace
--Not Named--tableLUWStorageTabledataPartitionsLUWDataPartition
--Not Named--tableLUWStorageTabledataPartitionKeyLUWDataPartitionKey


Generalization Relationships
NameClassSupplier
--Not Named--LUWTableDB2Table
--Not Named--LUWTableLUWStorageTable
--Not Named--DB2TablePersistentTable
--Not Named--PersistentTableBaseTable
--Not Named--BaseTableTable
--Not Named--TableSQLObject
--Not Named--SQLObjectENamedElement
--Not Named--ENamedElementEModelElement
--Not Named--EModelElementEObject



Property Settings

Data Modeler
dmItemFalseDMName 
IsTableFalseIsViewFalse
IsDomainFalseIsSPPackageFalse
Synonymns TableSpaceID 
SourceId SourceType 
CorrelationName SelectClause 
IsUpdateableTrueCheckOptionNone
IsSnapShotFalseIsDistinctFalse
PersistToServer IsPackageFalse