REPLACE FUNCTION SYSLIB.QueryBandReservedNames_TBF (
) RETURNS TABLE (
Queryband_Name VARCHAR(128) CHARACTER SET UNICODE,
Release_Introduced CHAR(5) CHARACTER SET LATIN,
Release_Dropped CHAR(5) CHARACTER SET LATIN,
Category CHAR(1) CHARACTER SET LATIN,
[ Max_Len INTEGER, ]
Default_Value VARCHAR(256) CHARACTER SET UNICODE,
Description VARCHAR(512) CHARACTER SET UNICODE,
Queryband_Type CHAR(1) CHARACTER SET LATIN
)
;
REPLACE VIEW SYSLIB.QueryBandReservedNames AS
SELECT Queryband_Name, Category, Max_Len,
Default_Value, Description, Queryband_Type
FROM TABLE (QueryBandReservedNames_TBF()) AS t1
WHERE Release_Dropped IS NULL
;
Syntax Elements
- Queryband_Name
- Name of the query band.
- Release_Introduced
- Version number of when the query band name was introduced.
- The version number is at the granularity of a minor release in standard format (that is, two digits for a major release number followed by a period and two digits for a minor release number). For example, '15.0' and '15.10'.
- Category
- Query band name category:
- T = Teradata restricted name (directive to the database)
- A = Application query band name (recommended for use by Teradata, Customer, and Partner applications)
- I = Teradata internal name (for internal Teradata use)
- Max_Len
- [Optional] Maximum length of the value for the property.
- Default: 256
- Default_Value
- Default value of the property, which is NULL.
- Description
- Description of how the query band name is used and whether the name is appropriate for a session or transaction query band, or both.
- Queryband_Type
- Query band type:
- S = The session query band.
- T = The Transaction query band.
- B = The session and transaction query band.