***********************
Your mail has been scanned by InterScan.
***********-***********



Dear All,

Dear all, though I had received couple of replies related to
truncate command. But it seems that these are non-logged operations and
hence will not reflect in my stand by site.

Request you all to kindly help me out with a DB2 truncate level
command which will be a logged operation. Also kindly let me know is
there any risk in using the same.

Thanks and regards
Dharmesh B

-----Original Message-----
From: Saiprasad_Parthasarathy
[mailto:db2udbdba-ezmlmshield-x16081335.[Email address protected]
Sent: Friday, June 22, 2007 10:51 AM
To: LazyDBA Discussion
Subject: RE: Truncate equivalent of Oracle required in DB2

***********************
Your mail has been scanned by InterScan.
***********-***********



Hi Dharmesh,
Try with this.
IMPORT FROM /dev/null OF DEL REPLACE INTO <table name>

Sai

-----Original Message-----
From: Dharmesh Kumar D. Bajpai
[mailto:db2udbdba-ezmlmshield-x73308630.[Email address protected]
Sent: Friday, June 22, 2007 10:30 AM
To: LazyDBA Discussion
Subject: Truncate equivalent of Oracle required in DB2


***********************
Your mail has been scanned by InterScan.
***********-***********


Dear All,

Kindly let me know 'truncate' equivalent of Oracle in DB2.

Regards
Dharmesh B






************************************************************************
***********
This message is for the named addressees' use only. It may contain NSDL

confidential, proprietary or legally privileged information. If you
receive

this message in error, please immediately delete it. You must not,
directly

or indirectly, use, disclose, distribute, print, or copy any part of
this message

if you are not the intended recipient.Unless otherwise stated, any
commercial

information given in this message does not constitute an offer to deal
on

any terms quoted. Any reference to the terms of executed transactions

should be treated as preliminary only and subject to our formal written

confirmation.
************************************************************************
***********


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





***********************************************************************************
This message is for the named addressees' use only. It may contain NSDL

confidential, proprietary or legally privileged information. If you receive

this message in error, please immediately delete it. You must not, directly

or indirectly, use, disclose, distribute, print, or copy any part of this message

if you are not the intended recipient.Unless otherwise stated, any commercial

information given in this message does not constitute an offer to deal on

any terms quoted. Any reference to the terms of executed transactions

should be treated as preliminary only and subject to our formal written

confirmation.
***********************************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page