Re: Multiset / Inline Select

That SYNTAX was not available in 7.31 You need IDS 9 or 10 to be able to use MULTISET Adam Tauno Williams wrote: > > I am running Informix 7.31.FD7 > > I would like to do an inline select. I found the SQL syntax for > > informix as: > > SELECT * FROM TABLE(MULTISET(SELECT * FROM mytable)) > > Though, it doesn't work and just gives a general syntax error.> > Works for me: > SELECT * FROM TABLE(MULTISET(SELECT * FROM oemr))> > > Do you know if the multiset is supported in my version (7.31) or is > > there another syntax I should be using? > > I don't think it worked in that old a version. We are running 10UC4. > I'm pretty certain it worked under 9.4.