The following extended attributes are defined by default in the Teradata DBMS.
The following extended attributes are available on the Teradata tab if the type is distinct (vV2R6 and higher):
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 |
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 |
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 |
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 |
The following extended attributes are available on the Teradata tab (vV2R6 and higher):
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 |
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 |