Re: Multiset / Inline Select

Adam Tauno Williams said: >> I am running Informix 7.31.FD7 It definitely won't work on 7.x. >> 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. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > -- Bye now, Obnoxio "... no bill is required as no value was provided." -- Christine Normile -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.