Hi Doug:
Use an import from /dev/null into table. This should empty the table and
free the space used by it.
-- Vijay
----- Original Message -----
From: "Doug Carter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 1:10 PM
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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
