The following statement executes the OneNode 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 single node, node 123-02.
EXECUTE ResCpuByAmpOneNode ('2006-12-25','2006-12-31',080000, 240000,'123-02');
where:
| Statement Element | Description |
|---|---|
| ResCPUByAMPOneNode | 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' | Node |
For information on using numeric values for dates, see Teradata Vantage™ - Data Types and Literals, B035-1143.