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

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
kak1592015099875.ditamap
dita:ditavalPath
kak1592015099875.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantage™

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.