TITLE Phrase Rules - Teradata Vantage - Analytics Database

SQL Data Types and Literals
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
uds1628112204571.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
exs1472253032394
lifecycle
latest
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';

Result:

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;

Result:

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;

Result:

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;

Result:

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;

Result:

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);

Result:

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;

Result:

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;

Result:

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;

Result:

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.