RE: DB2EUG: Delete witout logging

[Goldberg, Howard (USPC.PCT.Hopewell)]

You have to create the table using the "not logged initially" option.  Prior to 
running the delete and within the same commit scope, you must alter the table to 
activate the "no logging" option followed immediately by the delete option.  OR, you 
can load the table with the "not logged" option using /dev/null to clear out the table.

-----Original Message-----
From: Doug Carter [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 2:10 PM
To: [EMAIL PROTECTED]
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



=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod