Common Table Expression

[Colin]

Hi, I am relatively new to Sybase so apologies if this is in
the wrong place. I was attempting to use the 'with
recursive' statement but came across a syntax error. It
turned out that I was reading the Sybase Anywhere
documentation rather than the Adaptive Server Enterprise
documentation. As I can't find the 'With' keyword in the ASE
documentation I am assuming ASE doesn't support Common Table
Expressions. Can someone confirm this and let me know if
there are any plans to add support in a future release? I'm
on ASE 12.5.1.

Regards,
Colin

[Sherlock, Kevin [TeamSybase]]

You are correct, there is no support for what you call "Common Table
Expression" in ASE. I'm not aware of any plans to add that support, but I'm
not the right person to answer that.

There is support for "derived tables" which is essentially an embedded
SELECT statement in the FROM clause. In some cases, that can accomplish the
same thing.

http://infocenter.sybase.com/help/topic/com.sybase.dc37429_1251/html/whatsnew/CHDJDCJH.htm

<Colin> wrote in message news:49e485a4.242...@sybase.com...

[Carl Kayser]

<Colin> wrote in message news:49e485a4.242...@sybase.com...

There was ISUG Enhancement Request 3376 submitted October 2008 for including
the ANSI-99 "with" clause for non-correlated subqueries. I suspect that it
doesn't include "recursive". I find the ASE track record for enhancements
to be erratic. Sometimes it takes "forever" to get some functionality
(e.g., variances and standard deviations) and, on the other hand, some
enhancements are provided but not announced in the "What's new"
documentation (e.g., ANSI Full Match for foreign keys and "create database
... with dbid=value").

[Colin]

Ok, thanks for both responses.

Regards,
Colin

> "create database .... with dbid=value").
>
>