Executing a Macro

Database
Enthusiast

Executing a Macro

Hi ,

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

(

C_name  varchar(30),

 V_name varchar(30)

)

as

(

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!

Tags (2)