Doug; No truncate in DB2. A close equivalent is to do a LOAD REPLACE with an empty input file. Your data will disappear immediately. Regards, Scott Saunders Siebel Systems, Inc. Opinions expressed are my own and not those of my employer. -----Original Message----- From: Doug Carter [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 11:10 AM 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
