RE: DB2EUG: Delete witout logging

[Lewis, Bob]

Title: RE: DB2EUG: Delete witout logging

Or....you could do a load with a 'nullfile' input and the replace option.

 

Bob

-----Original Message-----
From: Philip Gunning [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 5:44 PM
To: [EMAIL PROTECTED]
Subject: RE: DB2EUG: Delete witout logging

  Doug, There is no truncate command. Take a look at the alter tname  not logged initially option and you should be able to accomplish the same thing. This is available in V7.1, not sure if available in a fixpack to V6.1

 Phil

-----Original Message-----
From: Doug Carter
To: [EMAIL PROTECTED]
Sent: 6/11/01 11:10 AM
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