15.10 - SelectAllExcludedObjects - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

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 SQL External Routine Programming.

 

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.

    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