var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Code for Emptying table inside a Stored Procedure
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").
you can use
alter table <table_name> activate not logged initially with empty table
Only if the table was created with the NOT LOGGED INITIALLY clause.
thanks ARwinner.. that is very true.