to create table inside stored procedure

[perl iyer]

im trying to create a table in DB2 EXPRESS C for example

create procedure TEST
dynamic results sets
p1: begin

begin
execute immediate'
create table abc
(
empid numeric
);
end;

how can i do this? please help. once i write this procedure table should be created

[Anas Mosaad]

Only this statement is enough:

 create table abc
(
empid numeric
);

Unless you want to create dynamic tables you will use execute immediate.