Re: Large Delete Problem

Posted in 1997

Gregory Krasnow — Tue, 18 Mar 1997 08:48:43 -0800 — source: Informix-list mailing list archive (1991-1998)

Sean Wong wrote: -- snip -- > You said you don't want to drop & recreate the table, why? This is the = > most easy and fast way. If you want to have a copy of the table, you = > can always unload it to a file before it get deleted. > > Any way, to answer your question, why don't you just declare a delete = > counter. I can only give you some peudocodes as I have not programmed = > for a long while: > 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