Could someone help me with the following. Since I have the create table option within the macro, I need to change the tablename everytime I execute this macro with different parameters.
Is there a way around it? without having to change the table name everytime I execute this macro.
create macro ex1
create multiset table table1 as
select * from tablename
where Cname =: C_name
and Vname =: V_name;
with data primary index (name);
exec ex1 (C_name ='XYZ',V_name='ABC')
Thank you in advance!