15.10 - TDWMExceptionRate - Teradata Database

Teradata Database Application Programming Reference

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

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

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

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

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