Re: INFORMIX WISH LIST

Posted in 1997

Bill Ennis — 26 Jun 1997 17:53:28 -0400 — source: Informix-list mailing list archive (1991-1998)

> > truncate table 'tablename' What does this do? Looks like it deletes? > > select a,b,c,... from 'tablename' into 'PERMANENT TABLE' Can't you use? ------------- INSERT INTO <table> SELECT a,b,c,... FROM <another_table>; > > I am very suprised that Informix (technology leader) lacks these two > critical operations. All the other vendors have it, why not Informix? > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net