16.20 - Example: Creating a Report of MiniCylPacks Between January and the Current Date - Teradata Vantage NewSQL Engine

Teradata Vantage™ SystemFE Macros

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
featnum
B035-1103-162K

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.