TITLE Phrase Rules - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantage™

Teradata SQL uses the following rules to generate a title for expression x:

IF x is … THEN …
a column reference with an explicit TITLE phrase that title value is returned.

Here is an example:

The explicit title for Project.ProjId, as defined in the CREATE TABLE statement for the Project table, is Project//Id.

The following statement returns the indicated result.

SELECT Proj_Id
FROM Project
WHERE Description='O/E Batch System';
Project
     Id
--------
OE2-0003
a column reference with no explicit TITLE the column name is returned.

Here is an example:

The Salary column has no explicit TITLE.

The following statement returns the indicated result.

SELECT Salary
FROM Employee
WHERE EmpNo = 10002;
Salary
---------
35,000.00
a constant TITLE is a character representation of that constant. The character representation of the constant could be the identical characters or a normalized form of the constant.

Here is an example:

The following statement returns 12 as the column heading for the value 12.

SELECT Name, 12
FROM Employee
WHERE EmpNo = 10003;
Name     12
-------  --
Leidner  12
of the form “operator y”, where operator is a unary (+ or -) or aggregate operator TITLE is ‘operator’ followed by ‘(y)’

Here is an example:

The following statement returns the aggregate operator name (SUM) as part of the column title.

SELECT SUM(Salary)
FROM Employee
WHERE DeptNo = 700;
Sum(Salary)
-----------
113,000.00
of the form

“y operator z”

y followed by “operator” followed by z.

Here is an example:

The following statement returns the headings of the column data for which the computation is performed and the operator.

SELECT Salary_Loan - 1000
FROM Employee_Loan
WHERE EmpNo = 10004;
Salary_Loan - 1000
------------------
          41000.00
an attribute function of the form “function (y)” TITLE is function, followed by (y).

Here is an example:

The following statement returns the indicated result.

SELECT FORMAT (Employee.EmpNo);
Format(EmpNo)
-------------
ZZZZ9
of the form

“y (data_description)”, where data_description does not contain a TITLE phrase or a NAMED phrase

TITLE is (y).

Here is an example:

The following statement returns the indicated result.

SELECT YrsExp (BYTEINT)
FROM Employee
WHERE EmpNo = 10016;
YrsExp
------
    20
of the form

“y (data_description)”, where data_description does not contain a TITLE phrase, but does contain a NAMED phrase

TITLE is the name that is specified in the NAMED phrase.

Here is an example:

The following statement returns the indicated result.

SELECT YrsExp (BYTEINT, NAMED YearsOfExperience)
FROM Employee
WHERE EmpNo = 10016;
YearsOfExperience
-----------------
               20
of the form

“y (data_description)”, where data_description contains a TITLE phrase

TITLE is the title that is specified by the phrase.

Here is an example:

The following statement returns the indicated result.

SELECT Salary (INTEGER, TITLE 'Pay')
FROM Employee
WHERE EmpNo = 10018;
Pay
-----
65000

The number of dashes used to define column width is an attribute of BTEQ.

You can modify this display by including a FORMAT phrase in the SELECT statement.