There is a way of deleting data from table (emptying table) in DB2, which is more effective than the normal delete statement. Below is the command for that:

import from nul: of del replace into <table_name>

I have to use this kind of delete command inside a stored procedure. Can somebody please help me out on the way to do this?

Import is not allowed in Stored Procedure. Only SQL is allowed with a few exceptions (see the SQL Reference section on "SQL Procedure Statement").

Andy

you can use

alter table <table_name> activate not logged initially with empty table

mujeeb

mujeeb,
Only if the table was created with the NOT LOGGED INITIALLY clause.
Andy

thanks ARwinner.. that is very true.

mujeeb