Re: INFORMIX WISH LIST

MarkDenham@aol.com wrote: > > Tim > > Thought of another requirement I would like to see implemented: > Create table fred as (select col1, col2, col3 ...from table x)> Save a lot of legwork and is available in other competitor products.... > > Mark > MarkDenham@aol.com (home) > Denham.M@amstr.com (work) Would this just create the table or would it load the table also? If it loads, then its like someone elses suggestion for an 'into permanent' clause (like the 'into temp' select clause) e.g: select col1, col2... from table_x into permanent table_y Douglas Wilson