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;