Multiset / Inline Select

Posted in 2006

Summary

A user on Informix 7.31.FD7 wanted to use an inline (derived) table and tried the syntax SELECT * FROM TABLE(MULTISET(SELECT * FROM mytable)), but it only produced a general syntax error. He asked whether MULTISET is supported in version 7.31 or whether a different syntax should be used for inline selects. The thread contains only this single posting, with no replies, so no answer or workaround is recorded.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

in4mixDBA — 24 Oct 2006 12:03:36 -0700 — source: Usenet: comp.databases.informix

Hello all, 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. Do you know if the multiset is supported in my version (7.31) or is there another syntax I should be using? Thank You, have a great day, Dave in4mixDBA@gmail.com