|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface LUWTable
A representation of the model object 'Table'. 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.
The following features are supported:
LUWPackage.getLUWTable()
Method Summary | |
---|---|
java.lang.String |
getLogMode()
Returns the value of the 'Log Mode' attribute. |
org.eclipse.emf.common.util.EList |
getOptions()
Returns the value of the 'Options' containment reference list. |
java.lang.String |
getPartitionMode()
Returns the value of the 'Partition Mode' attribute. |
int |
getPCTFree()
Returns the value of the 'PCT Free' attribute. |
boolean |
isAppendMode()
Returns the value of the 'Append Mode' attribute. |
boolean |
isLockSizeRow()
Returns the value of the 'Lock Size Row' attribute. |
boolean |
isRestrictOnDrop()
Returns the value of the 'Restrict On Drop' attribute. |
boolean |
isVolatile()
Returns the value of the 'Volatile' attribute. |
void |
setAppendMode(boolean value)
Sets the value of the ' Append Mode ' attribute. |
void |
setLockSizeRow(boolean value)
Sets the value of the ' Lock Size Row ' attribute. |
void |
setLogMode(java.lang.String value)
Sets the value of the ' Log Mode ' attribute. |
void |
setPartitionMode(java.lang.String value)
Sets the value of the ' Partition Mode ' attribute. |
void |
setPCTFree(int value)
Sets the value of the ' PCT Free ' attribute. |
void |
setRestrictOnDrop(boolean value)
Sets the value of the ' Restrict On Drop ' attribute. |
void |
setVolatile(boolean value)
Sets the value of the ' Volatile ' attribute. |
Methods inherited from interface com.ibm.db.models.db2.DB2Table |
---|
getDataCapture, getPackages, setDataCapture |
Methods inherited from interface org.eclipse.wst.rdb.internal.models.sql.tables.BaseTable |
---|
getConstraints, getForeignKeys, getPrimaryKey, getReferencingForeignKeys, getUniqueConstraints |
Methods inherited from interface org.eclipse.wst.rdb.internal.models.sql.tables.Table |
---|
getColumns, getIndex, getSchema, getSelfRefColumnGeneration, getSubtables, getSupertable, getTriggers, getUdt, isInsertable, isUpdatable, setSchema, setSelfRefColumnGeneration, setSupertable, setUdt |
Methods inherited from interface org.eclipse.wst.rdb.internal.models.sql.schema.SQLObject |
---|
addEAnnotation, addEAnnotationDetail, getComments, getDependencies, getDescription, getEAnnotation, getEAnnotationDetail, getLabel, getPrivileges, removeEAnnotationDetail, setAnnotationDetail, setDescription, setLabel |
Methods inherited from interface org.eclipse.emf.ecore.sdo.EDataObject |
---|
getInstanceProperties |
Methods inherited from interface commonj.sdo.DataObject |
---|
createDataObject, createDataObject, createDataObject, createDataObject, createDataObject, createDataObject, delete, get, get, get, getBigDecimal, getBigDecimal, getBigDecimal, getBigInteger, getBigInteger, getBigInteger, getBoolean, getBoolean, getBoolean, getByte, getByte, getByte, getBytes, getBytes, getBytes, getChar, getChar, getChar, getContainer, getContainmentProperty, getDataGraph, getDataObject, getDataObject, getDataObject, getDate, getDate, getDate, getDouble, getDouble, getDouble, getFloat, getFloat, getFloat, getInt, getInt, getInt, getList, getList, getList, getLong, getLong, getLong, getSequence, getSequence, getSequence, getShort, getShort, getShort, getString, getString, getString, getType, isSet, isSet, isSet, set, set, set, setBigDecimal, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBigInteger, setBoolean, setBoolean, setBoolean, setByte, setByte, setByte, setBytes, setBytes, setBytes, setChar, setChar, setChar, setDataObject, setDataObject, setDataObject, setDate, setDate, setDate, setDouble, setDouble, setDouble, setFloat, setFloat, setFloat, setInt, setInt, setInt, setList, setList, setList, setLong, setLong, setLong, setShort, setShort, setShort, setString, setString, setString, unset, unset, unset |
Methods inherited from interface org.eclipse.emf.ecore.ENamedElement |
---|
getName, setName |
Methods inherited from interface org.eclipse.emf.ecore.EModelElement |
---|
getEAnnotations |
Methods inherited from interface com.ibm.db.models.db2.luw.LUWStorageTable |
---|
getDataPartitionKey, getDataPartitions, getIndexDataTableSpace, getLOBDataTableSpace, getPartitionKey, getRegularDataTableSpace, getTableSpaces, isRowCompression, isValueCompression, setDataPartitionKey, setIndexDataTableSpace, setLOBDataTableSpace, setPartitionKey, setRegularDataTableSpace, setRowCompression, setValueCompression |
Method Detail |
---|
int getPCTFree()
If the meaning of the 'PCT Free' attribute isn't clear, there really should be more of a description here...
setPCTFree(int)
,
LUWPackage.getLUWTable_PCTFree()
void setPCTFree(int value)
PCT Free
' attribute.
value
- the new value of the 'PCT Free' attribute.getPCTFree()
boolean isRestrictOnDrop()
If the meaning of the 'Restrict On Drop' attribute isn't clear, there really should be more of a description here...
setRestrictOnDrop(boolean)
,
LUWPackage.getLUWTable_RestrictOnDrop()
void setRestrictOnDrop(boolean value)
Restrict On Drop
' attribute.
value
- the new value of the 'Restrict On Drop' attribute.isRestrictOnDrop()
java.lang.String getPartitionMode()
setPartitionMode(String)
,
LUWPackage.getLUWTable_PartitionMode()
void setPartitionMode(java.lang.String value)
Partition Mode
' attribute.
value
- the new value of the 'Partition Mode' attribute.getPartitionMode()
boolean isAppendMode()
If the meaning of the 'Append Mode' attribute isn't clear, there really should be more of a description here...
setAppendMode(boolean)
,
LUWPackage.getLUWTable_AppendMode()
void setAppendMode(boolean value)
Append Mode
' attribute.
value
- the new value of the 'Append Mode' attribute.isAppendMode()
java.lang.String getLogMode()
setLogMode(String)
,
LUWPackage.getLUWTable_LogMode()
void setLogMode(java.lang.String value)
Log Mode
' attribute.
value
- the new value of the 'Log Mode' attribute.getLogMode()
boolean isLockSizeRow()
setLockSizeRow(boolean)
,
LUWPackage.getLUWTable_LockSizeRow()
void setLockSizeRow(boolean value)
Lock Size Row
' attribute.
value
- the new value of the 'Lock Size Row' attribute.isLockSizeRow()
boolean isVolatile()
If the meaning of the 'Volatile' attribute isn't clear, there really should be more of a description here...
setVolatile(boolean)
,
LUWPackage.getLUWTable_Volatile()
void setVolatile(boolean value)
Volatile
' attribute.
value
- the new value of the 'Volatile' attribute.isVolatile()
org.eclipse.emf.common.util.EList getOptions()
LUWOption
.
If the meaning of the 'Options' containment reference list isn't clear, there really should be more of a description here...
LUWPackage.getLUWTable_Options()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |