Hi all,

Is it possible to have an anonymus SQL block in DB2??

Like in Oracle:

DECLARE
BEGIN
END;

How can I execute anonymus SQL block in db2?

Thanks

Vasja Chlen

Hi All,

I don't see any answers.
Does it mean nobody performed migration from Oracle to Db2? :-)

Thanks,

Vasja Chlen

yes I migrated DB from Oracle8i to DB2 UDBV8,

you can

use SQL block in db2 V8 as DB2 stored procedure


from run , type db2dc , that will take you to development center , you build SQL stored procedures or JAVA, in DB2 UDB V8 , you can use even VB



Let me know , if you need any syntax


Lekharaju Ennam
Certified Oracle8i & DB2 UDB DBA
Florida A&M University