Teradata Extended Attributes

The following extended attributes are defined by default in the Teradata DBMS.

Abstract Data Types

The following extended attributes are available on the Teradata tab if the type is distinct (vV2R6 and higher):

Name

Description

Predefined data type

Indicates that character column comparison uses character case (upper and lower) to raise differences.

Scripting name: PredefinedDataType

Abstract Data Type Procedures

The following extended attributes are available on the Teradata tab if the type is distinct (vV2R6 and higher):

Name

Description

Return data type

Specifies the name of the data type returned by the method, which can be either a predefined data type or a UDT.

Scripting name: ReturnDataType

Self as result

Specifies that the method is type-preserving. If so, then the data type specified in the RETURNS clause for the method must have the same name as UDT_name.

Scripting name: SelfAsResult

As locator

Specifies that BLOB and CLOB types must be represented by a locator. The Teradata Database does not support in-memory LOB parameters: an AS LOCATOR phrase must be specified for each LOB parameter and return value.

Scripting name: ReturnAsLocator

Character set

Specifies the CHARACTER SET clause for character data type.

Scripting name: ReturnCharSet

Cast data type

Specifies a computed attribute that show the datatype and its length and precision.

Scripting name: CastDataTypeDisplay

As locator

Specifies that BLOB and CLOB types must be represented by a locator.

Scripting name: CastAsLocator

Specific method name

Specifies the specific name of the method whose signature is being added to the type definition for UDT_name.

Scripting name: SpecificMethodName

Parameter style

Specifies the parameter style for the method defined by this signature.

Scripting name: ParameterStyle

Returns null on null input

Specifies that the method defined by this signature is not called if any of the arguments passed to it is null. Instead, it returns a null.

Scripting name: ReturnsNullOnNullInput

Deterministic

Specifies that the result of invoking the method defined by this signature is deterministic.

Scripting name: Deterministic

Language

Specifies the language (either C or C++) used to write the source code for the method defined by this signature.

Scripting name: Language

Columns

The following extended attributes are available on the Teradata tab (vV2R6 and higher):

Name

Description

Case specific

Specifies that character column comparison is case-sensitive.

Scripting name: CaseSpecific

Character set

Specifies the character set to be used.

Scripting name: CharacterSet

System generated only

Specifies that identity column values are always system-generated. You cannot insert values into, nor update, an identity column defined as GENERATED ALWAYS.

If not selected, identity column values are system-generated unless 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

Databases

The following extended attributes are available on the Teradata tab (vV2R6 and higher):

Name

Description

Account

Specifies the 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

Specifies 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

Owning database

Specifies the 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

Specifies 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

Indexes

The following extended attributes are available on the Teradata tab:

Name

Description

Primary Index

Specifies that the index is the primary index.

Scripting name: PrimaryIndex

All

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

Index has name

Specifies that the index will be generated with its name (as Teradata allows index with no name).

Scripting name: NamedIndex

Tables

The following extended attributes are available on the Teradata tab (vV2R6 and higher):

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 - a temporary table definition is 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

Controls the treatment of duplicate rows. 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

Users

The following extended attributes are available on the Teradata tab :

Name

Description

Owner

Specifies the database (or user) that owns the current user.

Scripting name: DBOwner

Permanent

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

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

Specifies 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

Account

Specifies the account ID identifiers.

Scripting name: Account

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

After journal

Specifies the type of image to be maintained by default for data tables created in the new database.

Scripting name: AfterJournal

Default table

Specifies the default table that is to receive the journal images of data tables created in the new database.

Scripting name: DefaultJournalTable

Database

Specifies the default database name.

Scripting name: DefaultDatabase

Role

Specifies the default role for the user.

Scripting name: DefaultRole

Character set

Specifies the default character data type.

Scripting name: DefaultCharacterSet

Collation

Specifies the default collation for this user.

Scripting name: Collation

Time zone

Specifies the default time zone displacement for the user.

Scripting name: TimeZone

Date format

Specifies the default format for importing and exporting DATE values for the user.

Scripting name: DateForm

Profile name

Specifies a profile to the user.

Scripting name: Profile

Startup string

Specifies a startup string.

Scripting name: Startup

Views

The following extended attributes are available on the Teradata tab (vV2R6 and higher):

Name

Description

Lock type

Specifies the type of lock to be placed.

Scripting name: LockType

Locked object class

Specifies the type (class) of the object to be locked.

Scripting name: LockedClass

Locked object

Specifies the name of the object to be locked.

Scripting name: LockedObjt

No wait

Specifies that if the indicated lock cannot be obtained, the statement should be aborted.

Scripting name: NoWait