I'm trying to run a performance comparison between Oracle and Teradata. I've ported the data from our Oracle database, and now I'm trying to test the procedure rewritten as a macro. The proc is written in standard non-ANSI sql. It executes fine as-is in SQL Assistant, but every time I attempt to create the macro, the error "Query is invalid" is returned. Do macros only support ANSI sql?
Ok I've done some testing, and it looks like the Oracle (+) notication for the outer join sytax is the problem:
from t_1, t_2
where t_1.some_id = t_2.some_id (+);
SELECT Failed. 3706: Syntax error: expected something between '+' and ')'.