RE: Large Delete Problem

OK, then try to delete by row id if you like to take the risk, = especially in the IFMX 7.x env. The other way is to turn the logging off before you do the delete, but = based on your post, I don't think you have the permission to do that.=20 ---------- From: Gregory Krasnow[SMTP:gak@hnc.com] Sent: Tuesday, March 18, 1997 9:48 AM To: informix-list@rmy.emory.edu Subject: Re: Large Delete Problem Sean Wong wrote: -- snip -- > You said you don't want to drop & recreate the table, why? This is = the =3D > most easy and fast way. If you want to have a copy of the table, you = =3D > can always unload it to a file before it get deleted. >=20 > Any way, to answer your question, why don't you just declare a delete = =3D > counter. I can only give you some peudocodes as I have not programmed = =3D > for a long while: >=20 First off, the program which will be doing the table truncation and deletes is written in C, not in ESQL/C or 4GL although it could call a strored procedure if needed. What Bappy and I were hopping for was something equivalent to either TRUNCATE TABLE in Oracle or DELETE ... WHERE ROWNUM < 1000 also available in Oracle. This is partially to try keep consistent between the version which runs against Oracle and the version which run against Informix. - Greg Greg Krasnow HNC Software Inc. Software Engineer/Payment Systems Email: gak@hnc.com Phone: 619.546.8877 x1341 Fax: 619.546.9464