Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Truncate in DB2

Status
Not open for further replies.
dataforums

dataforums

Programmer
May 3, 2005
25
US
Does anyone know how to 'truncate' a table in DB2? Truncate in Oracle and SQL server is used to completely delete all rows in a table without any logging. But this doesn't seem to work in DB2.
Please Help!!

Thanks!
 
Sort by date Sort by votes
Hi dataforums,
What platform and version of db2 are you using?
Marc
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

P
  • Locked
  • Question
DB2 LUW SYSCATSPACE is full
Replies
0
Views
251
prashant_0701
P
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
195
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
166
mikrom
mikrom
walter.weinmann
  • Locked
  • Question
Docker Iage IBM Db2 11.5.6.0: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
Replies
0
Views
206
walter.weinmann
walter.weinmann
Rohit K Gupta
  • Locked
  • Question
DB2 Equivalent of IGNORE_DUP_KEY
Replies
0
Views
86
Rohit K Gupta
Rohit K Gupta

Part and Inventory Search

Sponsor

Back
Top