Doug,
I believe I asked IBM this same question. I think the answer was run load
REPLACE with a null input file.
Roy
Doug Carter wrote:
> 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
