Hi,
I have a similar issue with one of our views too.
We have a view that uses count.
Create view vCountColumn (counter) as
Select count(c1) from t1
Now we have a different view that tries to using it (together with other views):
Create view vStats as
Select vInfo.info, vCountColumn.counter from vInfo, vCountColumn
That gives an:
General error;-7021 POS(XXX) View column derived from function not allowed:
counter
Hmmh, works on any other dbms we are using, but if there is a workaround...
So I tried to replace it by
Create view vStats as
Select vInfo.info, counter
from vInfo,
(Select count(c1) as counter from t1)
This gives the not yet implemented.
Kind regards,
Ronald
-----Original Message-----
From: Jens-Peter C. Hillers [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 1:57 PM
To: [EMAIL PROTECTED]; [email protected]
Subject: AW: Question about : "Not yet implemented:SELECT IN FROM PART OF VIEW"
Hi,
Have you tried first to make an view of the select you use in the from
clause ?
create V1 as
select f1,f2.f3 from T1 where F4 = 4711
create V2 as
select anything
FROM V1,......
WHERE ......
regards
jph
___________________________
Dipl.-Ing. Jens-Peter C. Hillers
Remote Web Services GmbH
Tel: +49 40 25 49 06 22
Fax: +49 40 36 00 67 27
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
____________________________
> -----Ursprüngliche Nachricht-----
> Von: Michael Hennessy [mailto:[EMAIL PROTECTED]
> Gesendet am: Montag, 1. August 2005 08:22
> An: [email protected]
> Betreff: Question about : "Not yet implemented:SELECT IN FROM PART OF
> VIEW"
>
>
> Hi all,
>
> I've got a maxdb v7.5.0 install and am getting this error when I try to
> create a view that is based on a query statement with a select in its FROM
> part:
>
> "Not yet implemented:SELECT IN FROM PART OF VIEW"
>
> Does anyone know if any of the later versions implement this as yet?
>
> Thanks in advance for any help.
>
> regards,
>
> Michael Hennessy
>
>
>
>
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
