Hi,

Is it possible to have an anonymus block and execute in DB2??

Like in Oracle we can create a anonymus PL/SQL block and execute it.

Sample Oracle PL/SQL Block.

BEGIN
NULL;
END;

the above block is an anonymus PL/SQL block, its not a stored procedure.

Thanks in advance
Hemanth

Check out Chapter 2, SQL Control Statements, in the SQL Reference vol 2.