Error message creating DDL's within macro

Database

Error message creating DDL's within macro

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?
1 REPLY
Enthusiast

Re: Error message creating DDL's within macro

Hi,

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;
)

I think it should work.

Regards,
Gander