TDWMExceptionRate Function | Application Programming Reference | Vantage - 17.10 - TDWMExceptionRate - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Returns the first record of the TDWM Exception request, which is the collection rate.

The SMALLINT data type returns the duration of the collection period in seconds. This value represents the collection rate.

Syntax

REPLACE FUNCTION TDWM.TDWMExceptionRate (
) RETURNS SMALLINT
  ...
;

Example: Using TDWMExceptionRate

SELECT TDWM.TDWMExceptionRate();
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
TDWMExceptionRate()
-------------------
                 60