Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can a view be used inside a derived tables?

0 views
Skip to first unread message

toedipper

unread,
Jul 25, 2008, 7:19:34 PM7/25/08
to
Hi all,

We have a Nortel symposium telecoms system which uses Sybase to store
details of all the calls etc.

Now, Symposium does not allow access to the tables so we have to use
pre-configed views.

There is no problem using this for basic selects.

However, can these views be used inside derived tables?

Why I ask...

This works

SELECT
blah
,blah
,blah
FROM
someview
WHERE
somefieldintheview = this


This does'nt

SELECT
*
FROM
(
SELECT
blah
,blah
,blah
FROM
someview
WHERE
somefieldintheview = this
) a

The above fails with 2 syntax errors, the first pointing at the 2nd
select and the 2nd pointing at the last bracket.

Any ideas?

cheers,

toe

Bret_Halford

unread,
Jul 28, 2008, 12:03:14 AM7/28/08
to
When you say "Sybase", which version of which Sybase product are you
asking about?

Does the version you are using support derived tables at all?

michael...@gmail.com

unread,
Jul 29, 2008, 8:16:52 AM7/29/08
to
On Jul 26, 1:19 am, toedipper <send_rubbish_here...@hotmail.com>
wrote:

Derived tables with views works (I use them in 12.5.4) - so my guess
(as Bret says) is that you have a version of ASE that doesn't support
derived tables.

Michael

toedipper

unread,
Aug 6, 2008, 5:42:08 PM8/6/08
to
Hi,

Can anyone tell me how to find out what version of Sybase I'm running?
I know it's ASE but I access it remotely, are there any commands/queries
I can type to display the exact version?

Cheers,

toe

ThanksButNo

unread,
Aug 6, 2008, 9:01:45 PM8/6/08
to
On Aug 6, 2:42 pm, toedipper <send_rubbish_here...@hotmail.com> wrote:

> Hi,
>
> Can anyone tell me how to find out what version of Sybase I'm running?
> I know it's ASE but I access it remotely, are there any commands/queries
> I can type to display the exact version?
>
> Cheers,
>
> toe

$ isql -Uuser -Ppassword -Etcetera
1> select @@version
2> go

toedipper

unread,
Aug 7, 2008, 4:01:24 PM8/7/08
to

Hi all,

Managed to find the version of Sybase we use (below) does this support
derived table and/or using views inside derived tables?

Cheers,

toe


Adaptive Server Enterprise/12.5.0.3/EBF 11449 ESD#4/P/NT
(IX86)/OS4.0/rel12503/1939/32-bit/OPT/Sat Sep 20 22:28:57 2003

michael...@gmail.com

unread,
Aug 8, 2008, 11:04:18 AM8/8/08
to
On Aug 7, 10:01 pm, toedipper <send_rubbish_here...@hotmail.com>
wrote:

No - you would need 12.5.1 or later.

Michael

0 new messages