Hi,


I have a requirement to create a table by selecting values from another table from inside a stored procedure. Can I do that?

I tried this statement:

create table db2inst1.cust_kpi_Wtd_temp1 as(select * from db2inst1.cust_kpi_Wtd_temp);


It gives me the error:

SQL0104N An unexpected token ";" was found following "1.cust_cust_kpi_wtd_temp)". Expected tokens may include: <definition_Only>".

I could create a table like
"create table db2inst1.cust_kpi_Wtd_temp1(cust_id varchar(12), b_date date)"


Thanks,
Kayal.

See discussions in this thread
Create a table from another table with data