>
>In Oracle and SQL Server there is a command called "TRUNCAT <tablename>".
>This command deletes all the contents in the specified table without
>logging. You won't be able to roll back the delete, but the delete will
>execute much faster since there is no logging.
>
>Is there an equivalent option in DB2?
>
>TIA,
>
>Doug Carter
>
Doug,
If you table was created using the 'not logged initially' option, they the
command:
alter table <table name> activate not logged initially with empty table
will work, without logging. If not, then deletes are logged. An easier way
than deletes would be to load replace using an empty file as input.
Regards,
Steve
___________________________
Steve Mazer
Senior Database Consultant
Fourth Millennium Technologies
IBM DB2 Gold Consultant
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
