SelectAllExcludedObjects

Teradata® Database Application Programming Reference

brand
Software
prodname
Teradata Database
vrm_release
16.20
category
Programming Reference
featnum
B035-1090-162K

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® Database 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