Usage Notes - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

Like SHOW statements, privilege on the object is required.

The result is a VARCHAR(64000) CHARACTER SET LATIN string containing a fixed seven-character right-justified character representation for each AMP (primary and fallback), up to a maximum of 1024 AMPs.

Errors are returned if:
  • The object does not exist.
  • The passed-in object is defined in a contiguous map.
  • The function is part of a query that references a table. The function can only be used in a query such as:
    SELECT SYSLIB.SparseTableAMPs('db1','tab1') dt;