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

.