Re: -999 Not implemented yet.
--Works!
Select first 10 X.*, A.*
from systables A,
Table( multiset(
Select first 10 tabname, tabid
from systables
)) X
where A.tabid = X.tabid
----------------------------------
-- Does not work.
-- Error: Not implemented yet. (State:S1000, Native Code: FFFFFC19)
----------------------------------/*
select first 10 X.*, A.*
from systables A,
Table( multiset(
Select first 10 tabname, tabid
from systables
where A.tabid = X.tabid --<---< error line position.
)) X
*/
Try it this way:
select first 10 X.*, A.*
from systables A,
Table( multiset(
Select first 10 tabname, tabid
from systables M
where A.tabid = M.tabid
)) X
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Wed, Jun 27, 2012 at 10:27 AM, <markbesaans@gmail.com> wrote:
> --Works!
> Select first 10 X.*, A.*
> from systables A,
> Table( multiset(
> Select first 10 tabname, tabid
> from systables
> )) X
> where A.tabid = X.tabid
> ----------------------------------
> -- Does not work.
> -- Error: Not implemented yet. (State:S1000, Native Code: FFFFFC19)
> ----------------------------------> /*
> select first 10 X.*, A.*
> from systables A,
> Table( multiset(
> Select first 10 tabname, tabid
> from systables
> where A.tabid = X.tabid --<---< error line position.
> )) X>
> */
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>