hi, Is it possible in a stored procedure, to insert rows in a table that has just been created a few lines above?? I am writing a stored procedure on DB2 and it understandably gives an error on deployment that the "table u r trying to insert values into dsnt exist"

EXECUTE IMMEDIATE 'Create table xyz(...... )'

INSERT INTO xyz VALUES(... . .);

I wud be grateful for any help,

Regards

You will need to put a 'commit' between 'CREATE TABLE' and 'INSERT'

You need to make the insert dynamic also:

EXECUTE IMMEDIATE 'Create table xyz(...... )'

execute immediate 'INSERT INTO xyz VALUES(... . .)'

Andy

Thanks a ton that worked..!!