RE: anything like MS-SQL "truncate" function in Informix?

Posted in 2004

Brian Minnick — Mon, 16 Aug 2004 13:11:04 -0400 — source: Usenet: comp.databases.informix

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C483B4.037D6D00 Content-Type: text/plain; charset="iso-8859-1" Yes, in version 9.4, there is the truncate statement. -----Original Message----- From: emebohw@netscape.net [mailto:emebohw@netscape.net] Sent: Monday, August 16, 2004 12:08 PM To: informix-list@iiug.org Subject: anything like MS-SQL "truncate" function in Informix? Is there something in Informix thats analagous to the truncate function in MSSQL Server truncate? Looking for a way to very quickly get rid of every row in a table. We have been dropping and recreating on the fly, but that has our programmers hard coding dbspaces into there apps which is probably not best practice. ------_=_NextPart_001_01C483B4.037D6D00 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45"> <TITLE>RE: anything like MS-SQL "truncate" function in Informix?</TITLE> </HEAD> <BODY> Yes, in version 9.4, there is the truncate statement. -----Original Message----- From: emebohw@netscape.net [<A HREF="mailto:emebohw@netscape.net">mailto:emebohw@netscape.net</A>] Sent: Monday, August 16, 2004 12:08 PM To: informix-list@iiug.org Subject: anything like MS-SQL "truncate" function in Informix? Is there something in Informix thats analagous to the truncate function in MSSQL Server truncate? Looking for a way to very quickly get rid of every row in a table. We have been dropping and recreating on the fly, but that has our programmers hard coding dbspaces into there apps which is probably not best practice. </BODY> </HTML> ------_=_NextPart_001_01C483B4.037D6D00-- sending to informix-list

↪ replying to Brian Minnick

Neil Truby — Mon, 16 Aug 2004 20:14:18 +0100 — source: Usenet: comp.databases.informix

"Brian Minnick" <BMinnick@belletire.com> wrote in message news:cfqrfv$r6a$1@news.xmission.com... > > -----Original Message----- > From: emebohw@netscape.net [mailto:emebohw@netscape.net] > Sent: Monday, August 16, 2004 12:08 PM > To: informix-list@iiug.org > Subject: anything like MS-SQL "truncate" function in Informix? > > > Is there something in Informix thats analagous to the truncate > function in MSSQL Server truncate?> This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > Yes, in version 9.4, there is the truncate statement. Is that right? I attended a briefing recently when this was heralded as a feature coming in 9.5.

Related threads

Glossary

dbspace