Doug,
If you created the table with the NOT LOGGED INITIALLY parameter,
then you can execute:
ALTER TABLE SCHEMA.TABLENAME ACTIVATE NOT LOGGED INITIALLY WITH EMPTY
TABLE;
Otherwise, you can use the IMPORT command:
IMPORT FROM /dev/null of DEL REPLACE INTO SCHEMA.TABLENAME
Good luck,
Ian
----- Original Message -----
From: "Doug Carter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 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
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
