Re: SELECT * FROM <sourcetable> INTO <newtable>
- From: "Doug Lawry" <lawry@xxxxxxxxxxxxx>
- Date: Fri, 31 Mar 2006 10:58:05 +0100
"OptionJ" <Option.J.Upton@xxxxxxxxx> wrote in message
news:1143790621.463498.265010@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- SELECT * FROM <sourcetable> INTO <newtable>
- From: OptionJ
- SELECT * FROM <sourcetable> INTO <newtable>
- Prev by Date: Re: SQL "transpose" question
- Next by Date: Re: DTS from informix to MS SQL 2000
- Previous by thread: Re: SELECT * FROM <sourcetable> INTO <newtable>
- Next by thread: Client SDK 2.90 on SunOS 9, which GNU compiler should I use
- Index(es):
Relevant Pages
|
