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
- Re: DB2EUG: Delete witout logging Doug Carter
- Re: DB2EUG: Delete witout loggin... Steve Mazer
- Re: DB2EUG: Delete witout loggin... Vijay Kartik
- Re: DB2EUG: Delete witout loggin... Roy
- Re: DB2EUG: Delete witout loggin... Ian D. Bjorhovde
- RE: DB2EUG: Delete witout loggin... Goldberg, Howard (USPC.PCT.Hopewell)
- RE: DB2EUG: Delete witout loggin... Philip Gunning
- RE: DB2EUG: Delete witout loggin... Lewis, Bob
- Re: DB2EUG: Delete witout loggin... creid
