Re: SELECT * FROM <sourcetable> INTO <newtable>

"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


.

Relevant Pages

  • Linked server issue
    ... data from a query that includes a joined table from another sql server. ... I am able to work around the error by inserting into a temp table, ... inserting the temp table into the permanent table or modifying the permanent ...
    (microsoft.public.sqlserver.server)
  • oninit -i failure
    ... I'm trying to startup informix for the first time on a CentOS 4.5 ... server. ... # Disk Mirroring Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: installing DBD-Informix on fedora 6
    ... usually i authenticate on the db server by adding a line to the .rhosts file belonging to root. ... my "stores" database is empty, i use it only for testing connections. ... ESQLTEST Program Running: ... Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC2 from /opt/informix ...
    (perl.dbi.users)
  • Re: Select from 2 Servers
    ... where is specified the Server? ... > You don't refer to the server, you refer to the Informix instance. ... >> columns in a table except the primary key could/should be nullable. ... > and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)