Thanks Serge.

For this to be executed within the application code would require the
application-db2-user to have alter privileges.. is it a good practice?

Also is truncate being planned for future DB2 implementations.

Thanks for your time and help.

Thanks,
Sumanth

"Serge Rielau" <srielau@ca.ibm.com> wrote in message
news:45hhd3F6pvlcU1@individual.net...
> Sumanth wrote:
>> Are there any implementations of truncate in db2. Is it going to be
>> implemented in the future?
>>
>> Is there an alternate way of doing a truncate of a table that has a high
>> record count without using "load" and is fast?
> ALTER TABLE T ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
> COMMIT;
>
> Cheers
> Serge
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab