shsandeep wrote:
Is there any solution to overcome this issue eg: some Procedure to delete
the data which can be called by DataStage?
Hmm... I'll lift the secret at the IM Conference in The Hague
http://www-304.ibm.com/jct03001c/ser...age&c=a0009439
OK, ok....here is the procedure
CREATE PROCEDURE purgeInventory(IN dt DATE)
BEGIN
DECLARE SQLCODE INTEGER;
loop: LOOP
DELETE FROM
(SELECT 1 FROM Inventory
WHERE InvDate <= dt
FETCH FIRST 1000 ROWS ONLY) AS D;
IF SQLCODE = 100 THEN
LEAVE loop;
END IF;
COMMIT;
END LOOP loop;
END
CALL purgeInventory(‘2003-10-01’)
Note that you can also use
ALTER TABLE ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
COMMIT;
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab