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>
<P><FONT SIZE=2>Yes, in version 9.4, there is the truncate statement.</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: emebohw@netscape.net [<A HREF="mailto:emebohw@netscape.net">mailto:emebohw@netscape.net</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, August 16, 2004 12:08 PM</FONT>
<BR><FONT SIZE=2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=2>Subject: anything like MS-SQL "truncate" function in Informix?</FONT>
</P>
<BR>
<P><FONT SIZE=2>Is there something in Informix thats analagous to the truncate</FONT>
<BR><FONT SIZE=2>function in MSSQL Server truncate?</FONT>
</P>
<P><FONT SIZE=2>Looking for a way to very quickly get rid of every row in a table. We</FONT>
<BR><FONT SIZE=2>have been dropping and recreating on the fly, but that has our</FONT>
<BR><FONT SIZE=2>programmers hard coding dbspaces into there apps which is probably not</FONT>
<BR><FONT SIZE=2>best practice.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C483B4.037D6D00--
sending to informix-list
↪ replying to Brian Minnick
"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.