...
Holds all the parameters required for a view definition.
| Attribute | Definition |
|---|
name | Required. Holds the view name. The name should follow the naming conventions specified in Naming conventions. |
type | Required. Specifies the view type and can hold one of the following values: STATISTICS A PMDB view that holds information about certain database activity, summarized into hours or time slices.INTERNAL A PMDB view that keeps any other, non-statistical information.
|
view-columns | Required. Its value is in the view columns separated by blanks. The number of columns should be equal to the number selected in the as-query attribute. |
as-query | Required. Specifies the select table that defines the view. |
check-option | Optional. Default value is FALSE. If the value is TRUE, only modifications that are visible through the view are allowed, meaning that INSERT and UPDATE statements are valid only if the affected rows can be retrieved by the view afterward. |
<column-definition> tag
Holds all the parameters of a column.
| Attribute | Definition |
|---|
name | Required. Holds the column name. The name should follow the naming conventions specified in Naming conventions. |
data-type | Required. Holds the data type of a column: BOOLEAN Does not require data-length or data-scale attributes. These attributes should not be specified. Implementation on all DBMSs:CHAR(1) where T is the boolean TRUE value and F is FALSE.
CHAR Requires data-length attribute. Implementation on all DBMSs:CLOB Requires data-length attribute. Implementation:TEXT for Microsoft SQL ServerCLOB for Oracle
DECIMAL Requires data-length (used for precision) and data-scale attributes. Implementation:NUMBER(data-length, data-scale) for Microsoft SQL Server and IBM UDB Oracle
FLOAT Requires data-length attribute. Implementation:FLOAT(data-length) for Microsoft SQL ServerNUMBER without any parameters for Oracle
INTEGER Requires data-length attribute. Implementation:data-length less than three: TINYINT; data-length two-to-four: SMALLINT; data-length more than four: BIGINT for Microsoft SQL ServerNUMBER(data-length) for Oracle
TIMESTAMP Does not require data-length or data-scale attributes. These attributes should not be specified. Implementation:DATETIME for Microsoft SQL ServerTIME for Oracle
UNIQUE INTEGER Does not require data-length or data-scale attributes. These attributes should not be specified. This is a data type for a unique integer whose values are generated automatically. Implementation:IDENTITY for Microsoft SQL ServerNUMBER(20,0) for Oracle. In addition, a SEQUENCE and a TRIGGER BEFORE INSERT are created, which select the NEXTVAL of the SEQUENCE from DUAL.
VARCHAR Requires the data-length attribute. Implementation:VARCHAR(data-length) for Microsoft SQL ServerVARCHAR2(data-length) for Oracle
VARBINARY Requires the data-length attribute. Implementation:VARBINARY(data-length) for Microsoft SQL ServerRAW(data-length) for Oracle
|
data-length |
|
data-scale |
|
null |
|
default |
|
type |
|
| Scroll Ignore |
|---|
| scroll-pdf | true |
|---|
| scroll-office | true |
|---|
| scroll-chm | true |
|---|
| scroll-docbook | true |
|---|
| scroll-eclipsehelp | true |
|---|
| scroll-epub | true |
|---|
| scroll-html | true |
|---|
|
|