Doug:
You can load a 0 byte file into a large table. This will truncate the table
in the same manner as Oracle & Sql Server.
Charles
Doug Carter <[EMAIL PROTECTED]>@lists1.ba.best.com on 06/11/2001
02:10:27 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: DB2EUG: Delete witout logging
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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
Doug Carter <[EMAIL PROTECTED]>@lists1.ba.best.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
