16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
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;