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);
Could you please check your Transaction MODE to TERA or ANSI.
Make sure SQLA and Studio are having same Transaction modes.
TMODE on both ANSI - I get results from regular query work. Results say good but no data returned except column headings.
Sorry to ask you gain.
Do you mean you are getting different result sets with Studio and SQLA even both have same
If possible ,Could you please provide some sample data to try locally