SelectAllExcludedObjects Stored Procedure | Teradata Vantage - 17.05 - SelectAllExcludedObjects - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

Displays the list of all user objects whose collections are explicitly excluded from Automated Statistics Management.

Definition

REPLACE PROCEDURE TDSTATS.SelectAllExcludedObjects()
           .
           .
           .
;

Returning Result Set

The output of this external stored procedure is in the form of a stored procedure dynamic result. That is, the external stored procedure can return result sets to the client application or to the caller of the external stored procedure (in addition to consuming the result sets itself) upon completion of the external stored procedure.

For more information about stored procedure dynamic result sets, see Teradata Vantageā„¢ - SQL External Routine Programming , B035-1147 .

Output Parameters

Parameter Description
ObjectType Type or level of exclusion:
  • D (Database)
  • T (Table)
DatabaseName Excluded database or the database containing the excluded table.
TableName Table to be excluded if ObjectType is T. For details, see the ObjectType output parameter.
CreatedTimeStamp Time when the object was excluded.
CreateUser User who imposed the exclusion.

Example: Using SelectAllExcludedObjects

The following example shows how to retrieve a report of all excluded objects defined for the Automated Statistics Management feature.

CALL TDSTATS.SelectAllExcludedObjects;
*** Query completed. 3 rows found. 6 columns returned.
 *** Total elapsed time was 1 second.
ObjectType  DatabaseName  TableName    CreatedTimeStamp    CreateUser
----------  ------------  ---------    ----------------    ----------
    T       PERSONNEL     PROJECT      2010-09-01 23:46:29 DBC
    T       PERSONNEL     DEPARTMENT   2010-09-01 23:48:34 DBC
    T       SALES         SUPPLIER     2010-09-05 21:31:35