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

#1 (**permalink**) 04-20-2008, 07:26 AM

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

#2 (**permalink**) 04-20-2008, 07:26 AM

"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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode