The following statement executes the ResCPUByAMP macro, producing a report for the period beginning 8:00 a.m. on December 25, 2006 and ending 12:00 midnight, on December 31, 2006. It includes data for nodes 123-02 through 125-04.
EXECUTE ResCPUByAmp('2006-12-25','2006-12-31',
080000, 240000, '123-02','125-04');
where:
| Statement Element | Description |
|---|---|
| ResCPUByAMP | 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 |
| '123-02' | Starting node of a range of nodes |
| '125-04' | Ending node of a range of nodes |
For information on using numeric values for dates, see Teradata Vantage™ - Data Types and Literals, B035-1143.