Chapter 15 DBMS-Specific Features
The following extended attributes are defined by default in the Teradata DBMS.
The following extended attributes are available on the Teradata tab:
| Name | Description |
|---|---|
| Case specific | Indicates that character column comparison uses character case (upper and lower) to raise differences.
Scripting name: CaseSpecific |
| Character set | Character set (set of symbols and encodings.)
Scripting name: CharSet |
| System generated only | When set to true, identity column values are always system-generated; you cannot insert values into, nor update, an identity column defined as GENERATED ALWAYS.
When false, identity column values are system-generated as long as the user does not enter a non-null value. Scripting name: ExtGenAlways |
| Compressed values | Compresses specified values and nulls in one or more columns of a table to zero space. When the data in a column matches a value specified in the COMPRESS phrase, then that value is stored only once in the table header regardless of how many times it occurs as a field value for the column, thus saving disk storage space.
Attribute must be enclosed in parenthesis when it is composed of multiple values. Scripting name: Compress |
The following extended attributes are available on the Teradata tab:
| Name | Description |
|---|---|
| Account | Account ID identifiers.
Scripting name: Account |
| After journal | Specifies the type of image to be maintained by default for data tables created in the new database.
Scripting name: AfterJournal |
| Default journal table | Identifies the default table that is to receive the journal images of data tables created in the new database.
Scripting name: DefaultJournalTable |
| Fallback | Specifies whether to create and store a duplicate copy of each table created in the new database.
Scripting name: Fallback |
| Owner (User or Database) | Name of the immediate owning user or database. The default is the user name associated with the current session.
Scripting name: FromDatabaseName |
| Journal | Specifies the number of before change images to be maintained by default for each data table created in the new database.
Scripting name: Journal |
| Permanent space | Specifies the number of bytes to be reserved for permanent storage of the new user database. The space is taken from unallocated space in the database of the immediate owner.
Scripting name: PermanentSpace |
| Spool space | Specifies the number of bytes (n) to be allocated for spool files. The default is the largest value that is not greater then the owner spool space, and that is a multiple of the number of AMPs on the system.
Scripting name: SpoolSpace |
| Temporary space | Allows you to define how much space (in bytes) is to be allocated for creating temporary tables by this user. Note that temporary space is reserved prior to spool space for any user defined with this characteristic.
Scripting name: TemporarySpace |
The following extended attributes are available on the Teradata tab:
| Name | Description |
|---|---|
| Retain row ID pointers for each logical row "all" keyword) | Specifies that a NUSI should retain row ID pointers for each logical row of a join index (as opposed to only the compressed physical rows).
Scripting name: AllIndex |
| Generate index name | Specifies that the index will be generated with its name (as Teradata allows index with no name).
Scripting name: NamedIndex |
| Row ordering | Specifies the ordering of rows.
Scripting name: OrderByColumnList |
| Primary index | Indicates that the index is a primary index.
Scripting name: PrimaryIndex |
The following extended attributes are available on the Teradata tab:
| Name | Description |
|---|---|
| On commit action | Specifies the action to take with the contents of a global temporary table when a transaction ends.
DELETE ROWS clears the temporary table of all rows. PRESERVE ROWS retains the rows in the table after the transaction is committed. Scripting name: CommitRowAction |
| Type | Specifies whether the table to be created is a global temporary table or a volatile table.
GLOBAL TEMPORARY specifies that a temporary table definition be created and stored in the data dictionary for future materialization. You can create global temporary tables by copying a table WITH NO DATA, but not by copying a table WITH DATA. VOLATILE specifies that a volatile table be created, with its definition retained in memory only for the course of the session in which it is defined. Scripting name: GlobalTemporary |
| Duplicate row control | Specifies duplicate row control.
If there are uniqueness constraints on any column or set of columns in the table definition, then the table cannot have duplicate rows even if it is declared as MULTISET. Some client utilities have restrictions with respect to MULTISET tables. Scripting name: SetOrMultiset |
The following extended attributes are available on the Database tab:
| Name | Description |
|---|---|
| Account | Account ID identifiers.
Scripting name: Account |
| After journal | Specifies the type of image to be maintained by default for data tables created in the new database.
Scripting name: AfterJournal |
| Owner (User or Database) | Database (or User) that owns the current user.
Scripting name: DBOwner |
| Default journal table | Identifies the default table that is to receive the journal images of data tables created in the new database.
Scripting name: DefaultJournalTable |
| Fallback | Specifies whether to create and store a duplicate copy of each table created in the new database.
Scripting name: Fallback |
| Journal | Specifies the number of before change images to be maintained by default for each data table created in the new database.
Scripting name: Journal |
| Permanent space | Specifies the number of bytes to be reserved for permanent storage of the new user database. The space is taken from unallocated space in the database of the immediate owner.
Scripting name: PermanentSpace |
| Spool space | Specifies the number of bytes (n) to be allocated for spool files. The default is the largest value that is not greater then the owner spool space, and that is a multiple of the number of AMPs on the system.
Scripting name: SpoolSpace |
| Temporary space | Allows you to define how much space (in bytes) is to be allocated for creating temporary tables by this user. Note that temporary space is reserved prior to spool space for any user defined with this characteristic.
Scripting name: TemporarySpace |
The following extended attributes are available on the Teradata tab:
| Name | Description |
|---|---|
| Collation | Name of the collation to be used as the default for this user.
Scripting name: Collation |
| Default date format | Default format for importing and exporting DATE values for the user.
Scripting name: DateForm |
| Default character set | Sets the user default for character data type.
Scripting name: DefaultCharacterSet |
| Default database | Default database name.
Scripting name: DefaultDatabase |
| Default role | Defines the default role for the user.
Scripting name: DefaultRole |
| Profile | Assigns a profile to the user.
Scripting name: Profile |
| Startup string | Startup string.
Scripting name: Startup |
| Time zone | Defines the default time zone displacement for the user.
Scripting name: TimeZone |
The following extended attributes are available on the Teradata tab:
| Name | Description |
|---|---|
| Lock Type | The type of lock to be placed.
Scripting name: LockType |
| Locked Class | The type (class) of the object to be locked.
Scripting name: LockedClass |
| Locked object | The name of the object to be locked.
Scripting name: LockedObjt |
| Abort statement if lock failed | Specifies that if the indicated lock cannot be obtained, the statement should be aborted.
Scripting name: NoWait |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |