I am creating a DDL and within a macro and a Insert/Select within a macro. Then I am trying to execute both macro within a third macro via SQL Assistant. I am getting the following error message "Only an ET or null statement is legal after a DDL Statement". Does anyone know a way to do this with SQL Assistant?
In macro you can execute combination of SQL's. But you have to put your DDL SQL at last of the macro. And you can have only NULL after DDL SQL within macro. And one more thing you have to write your macro like this :
create macro macro_name as ( BEGIN TRANSACTION simple sql END TRANSACTION; DDL; )