SELECT * FROM <sourcetable> INTO <newtable>

I am told by my coworkers that Informix does not allow one to create permanent tables on the fly by using code as in my subject, only in to temp tables. The only way to put data in to permanent tables is to create a table first, and then INSERT INTO. Is this a limitation of Informix or is this perhaps something set up by our admins? I believe that we are using version 7.1. I've most recently been using MS SQL Server, where the above was allowed. It isn't a huge issue, but it has caused some trouble when we've been developing with others and need to share information quickly. Thanks, Option J Upton

only temp with select * from sometable into temp tessie with no log... not permanent... dbschema is a great tool to assist you. Superboer.

"OptionJ" <Option.J.Upton@gmail.com> wrote in message news:1143790621.463498.265010@t31g2000cwb.googlegroups.com... > I am told by my coworkers that Informix does not allow one to create > permanent tables on the fly by using code as in my subject, only in to > temp tables. The only way to put data in to permanent tables is to > create a table first, and then INSERT INTO. > > Is this a limitation of Informix or is this perhaps something set up by > our admins? I believe that we are using version 7.1. > > I've most recently been using MS SQL Server, where the above was > allowed. > > It isn't a huge issue, but it has caused some trouble when we've been > developing with others and need to share information quickly. > > Thanks, > > Option J Upton This isn't currently supported in even the latest version of Informix Dynamic Server, but is in Extended Parallel Server (XPS). This has already been suggested as a feature request in this news group. -- Regards, Doug Lawry www.douglawry.webhop.org