BTEQ Script Listing for DiskEvents Macro | SystemFE Macros | Teradata Vantage - 17.10 - DiskEvents - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Publication ID
B035-1103-171K
Language
English (United States)
REPLACE MACRO SystemFE.DiskEvents
 (Fromdate (date,               FORMAT 'YYYY-MM-DD'),
  Todate   (date, DEFAULT DATE, FORMAT 'YYYY-MM-DD')) AS
(
echo 'set defaults;';
echo 'set format on;';
echo 'set width 150;';
echo 'set NULL as "-";';
echo 'set separator 2;';
echo 'set pagelength 60;';
echo 'set omit on 1,2;';
echo 'set suppress on 3,4,5;';
echo 'set heading "&DATE||Disk Events Between &1 and &2||&TIME";';
Select   :Fromdate      (Format 'YYYY-MM-DD')
       , :Todate        (Format 'YYYY-MM-DD')
       , TheDate        (Title  'Date')
       , TheTime        (Title  'Time')
       , Text           (Title  'Message Text')
FROM   DBC.Software_Event_Log
Where  Event_Tag in (0331103600, 0331103800, 0331109400)
And    TheDate BETWEEN :fromdate AND :Todate
Order by TheDate, TheTime;
echo 'set defaults;';
);