Oninit cdi / Archive
Talk to an expert →

SQL construct not supported in informix ?

Posted in 2003

Topics: General Discussion

vk02720 — — source: Usenet: comp.databases.informix

The following SQL construct does not work in Informix 7.3 select a,b from (select col1 a, col2 b from mytable) This works in Oracle. Is this part of SQL standard or an Oracle extension ? TIA

↪ replying to vk02720
Art S. Kagel — — source: Usenet: comp.databases.informix

On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote: > The following SQL construct does not work in Informix 7.3 select a,b > from > (select col1 a, col2 b from mytable) > > This works in Oracle. > Is this part of SQL standard or an Oracle extension ? > > TIA Non-standard to the level of SQL that Informix supports. Art S. Kagel

↪ replying to Art S. Kagel
vk02720 — — source: Usenet: comp.databases.informix

"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:<pan.2003.07.17.18.01.18.408954.15473@bloomberg.net>... > On Thu, 17 Jul 2003 11:40:27 -0400, vk02720 wrote: > > > The following SQL construct does not work in Informix 7.3 select a,b > > from > > (select col1 a, col2 b from mytable) > > > > This works in Oracle. > > Is this part of SQL standard or an Oracle extension ? > > > > TIA > > Non-standard to the level of SQL that Informix supports. > > > Art S. Kagel Thanks. So what level of SQL standard does Informix support ? And again, is this construct a SQL standard ( as compared to purely an Oracle extension ) ? Any good website for SQL standard ?

Related threads