Could do the old fashioned following unit of work:

BEGIN WORK;
LOCK TABLE tablename;
DELETE FROM tablename WHERE 1=1;
COMMIT WORK;

I'm admittedly OLD SCHOOL....and my 4GL is a bit
rusty...but I think you get the gist... You could
write a Stored Procedure for each of the specific
tables in question.

Rob Vorbroker
--- sumGirl <emebohw@netscape.net> wrote:

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


=====
Rob Vorbroker Phone: 513/336-8695
Vorbroker Consulting, Inc. Fax: 513/336-6812
www.vorbroker.com robv@vorbroker.com
sending to informix-list