Studio 16.20 no data returned exec macro

Teradata Studio
Highlighted
Enthusiast

Studio 16.20 no data returned exec macro

I'm using the latest TD Studio 16.20 and funny when I'm executing resusage macro below it runs and returns zero rows.  But running same query in SQL Assistant it returns the past 30 days as expected.  I've not run into this at all with other queries but I suspect something odd in Studio's config or something ? 

PLEASE Help as I'm trying to get other to adopt Studio for the data movement features but keep running into usability issuses like this I cannot explain to them. 

 

EXEC SystemFe.gss_resusage_td1410(DATE-30, DATE, 0, 240000);

THANKS

Todd

3 REPLIES
Teradata Employee

Re: Studio 16.20 no data returned exec macro

Could you please check your Transaction MODE to TERA or ANSI.

Make sure SQLA and Studio are having same Transaction modes.

Enthusiast

Re: Studio 16.20 no data returned exec macro

TMODE on both ANSI - I get results from regular query work.  Results say good but no data returned except column headings. 

Teradata Employee

Re: Studio 16.20 no data returned exec macro

Sorry to ask you gain.

Do you mean you are getting different result sets with Studio and SQLA even both have same 

Transaction Mode.

 

If possible ,Could you please provide some sample data to try locally