Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: No data returned when executing a Teradata macro from within an MS Excel macro?
 
From:   McBride, Michael

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023