Skip to content

Tag: multiset

Informix doubly nested MULTISET remains empty

Given this schema: I tried running a query like this: But the output suggests that the inner most nested MULTISET query doesn’t work. The output is: Is this a known limitation or a bug? How can I work around this limitation? I’m using IBM Informix Dynamic Server Version 14.10.FC5DE Answer Just lik…

How to nest MULTISET in unnamed ROW in Informix?

Given this schema: The following query looks correct to me: But it produces some unspecified internal error: SQL Error [IX000]: User Defined Routine (collectionsend) execution failed. Is this a documented limitation? How can I work around this problem? I’m using IBM Informix Dynamic Server Version 14.10…