RE: Select into...

The Informix syntax is: insert into table2 select * from table1 -----Original Message----- From: Mako Joe [mailto:eyeofthestorm2@hotmail.com] Sent: Wednesday, October 13, 1999 7:59 PM To: informix-list@iiug.org Subject: Re: Select into... I may be wrong, and I've never tried this on Informix, but I think in Oracle you can do the following: create table2 as select * from table1 Jeff wrote in message ... >Hi, > >I am a MSSQL user trying to find the equivalent to a "Select into". What >this does is create a table from another table without writing to a log >file. Something like this... > >Select * into table1 from table2> >Is there something like this in Informix? > >Thanks in advance, >Jeff

This is just an insert statement and requires the table to exist William Raper <WilliamR@catmktg.com> wrote in message news:7u4j9n$dii$1@news.xmission.com... > > The Informix syntax is: > > insert into table2 select * from table1> > -----Original Message----- > From: Mako Joe [mailto:eyeofthestorm2@hotmail.com] > Sent: Wednesday, October 13, 1999 7:59 PM > To: informix-list@iiug.org > Subject: Re: Select into... > > > I may be wrong, and I've never tried this on Informix, but I think in Oracle > you can do the following: > create table2 as select * from table1 > > Jeff wrote in message ... > >Hi, > > > >I am a MSSQL user trying to find the equivalent to a "Select into". What > >this does is create a table from another table without writing to a log > >file. Something like this... > > > >Select * into table1 from table2> > > >Is there something like this in Informix? > > > >Thanks in advance, > >Jeff > >