The following statement executes the ByGroup version of the ResCPUByAmp macro shown in Example 1. It uses the same starting and ending dates and times (using character string format), except the report is for a node grouping.
EXECUTE ResAMPCpuByGroup ('2006-12-25','2006-12-31', 080000, 240000);
|ResAMPCpuByGroup||Name of the resource usage macro|
|'2006-12-25'||Starting date of December 25, 2006|
|'2006-12-31'||Ending date of December 31, 2006|
|080000||Starting time of 8:00 a.m.|
|240000||Ending time of 12:00 midnight|
For information on using numeric values for dates, see Teradata Vantage™ - Data Types and Literals, B035-1143.