Archives of the TeradataForum

Message Posted: Mon, 25 Nov 2002 @ 22:00:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

The teradata macro has four statements,

1) Call (execute) another macro that refreshes a summary table with res usage metrics

2) Delete from a global temp table

3) Insert "pivot" (by CASE) from the summary table (step #1) into the temp table

4) Select * from temp table

There are no abort statements embedded in the macro...

When I create a View to combine steps 3 and 4. I can use a "select" statement against that view in the Excel macro and it returns the data rows. The problem with this is that the parms on the Teradata macro pass in "start" and "end" dates that can't be changed dynamically in the view, which needs to pull back those dates as part of the "select" statement (the underlying summary data may not have metrics for the entire date range specified).

What I don't understand, is why MS Query executes the macro, and even post a dialog box stating a succesful execution, but returns no data rows...

	<Prev	Next>		<<First	<Prev	Next>	Last>>