16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

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;