17.00 - 17.05 - Example: Generating a MiniCylPacks Report Between January and the Current Date - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

The following statement gives a report of the MiniCylPacks between January 21, 2013, and the date of today:

Exec MiniCylPacks ('2013-01-21',);

The resulting report follows:

Exec MiniCylPacks ('2013-01-21',);

*** Query completed. 14 rows found. 6 columns returned.

13/01/21    MiniCylPacks Performed Between 2013-01-21 and 2013-01-21    21:49
 Vproc      Date             Time 	        Event
------  --------  ---------------  ------------
     1  			13/01/21  21:29:26.610000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 1 =      1
     2 		13/01/21 21:29:25.630000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 2 =      1
     3 		13/01/21 21:29:24.950000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 3 =      1
     4 		13/01/21 21:29:24.670000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 4 =      1
     5 		13/01/21 21:29:24.660000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 5 =      1
     6 		13/01/21 21:29:25.130000  34-05142-00
                                                      ------
**** Number of MiniCylPack log messages On vproc 6 =       1
     7 		13/01/21 21:29:25.250000  34-05142-00
                                                      ------
***** Number of MiniCylPack log messages On vproc 7 =      1

*** Query completed. No rows found.
*** Echo accepted.