Hi,
I am using the following statement for replacing the data in the table instead of deleting the records. If I do the delete the records which are in thousands, the transaction log will get filled up unnecessarily which I don't want to do. I use the following command to replace the data of the table.
load from C:\test.sql of ixf replace into alert_history;
where test.sql is a empty file and alert_history is the name of the table.
But the table records are not getting emptied.
May I know is there anything I need to do apart from this.
The alert_history table here has around 200,000 records and I am OK even if I loose the data of the table after replacement.
Please respond.
Thx
Shrini

The empty file cannot be ixf ...

It has to be del (not sure asc)

Cheers
Sathyaram

Hi Sathyaram,
Even del does not work.

Thx
Shrini

After execution of load command, what is the message which you are getting. Whether you are getting the message saying load is completed.

Another question i have is whether you any referential integrity on this table?

Check whether table is in pending state or not?

Nagesh

I have used ixf file to empty the table on AIX DB2 V7 FP9

dollar