Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Common Table Expression

4 posts in Product Futures Discussion Last posting was on 2009-04-24 11:51:32.0Z
Colin Posted on 2009-04-14 12:46:28.0Z
Sender: 2394.49e48077.1804289383@sybase.com
From: Colin
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Common Table Expression
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49e485a4.2424.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 14 Apr 2009 05:46:28 -0700
X-Trace: forums-1-dub 1239713188 10.22.241.41 (14 Apr 2009 05:46:28 -0700)
X-Original-Trace: 14 Apr 2009 05:46:28 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2024
Article PK: 97626

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] Posted on 2009-04-14 14:01:38.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <49e485a4.2424.1681692777@sybase.com>
Subject: Re: Common Table Expression
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49e49742$1@forums-1-dub>
Date: 14 Apr 2009 07:01:38 -0700
X-Trace: forums-1-dub 1239717698 10.22.241.152 (14 Apr 2009 07:01:38 -0700)
X-Original-Trace: 14 Apr 2009 07:01:38 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2025
Article PK: 97623

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.2424.1681692777@sybase.com...
> 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


Carl Kayser Posted on 2009-04-15 10:17:59.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <49e485a4.2424.1681692777@sybase.com>
Subject: Re: Common Table Expression
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49e5b457@forums-1-dub>
Date: 15 Apr 2009 03:17:59 -0700
X-Trace: forums-1-dub 1239790679 10.22.241.152 (15 Apr 2009 03:17:59 -0700)
X-Original-Trace: 15 Apr 2009 03:17:59 -0700, vip152.sybase.com
X-Authenticated-User: ase1251
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2026
Article PK: 97624


<Colin> wrote in message news:49e485a4.2424.1681692777@sybase.com...
> 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

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 Posted on 2009-04-24 11:51:32.0Z
Sender: 1053.49f1a6f4.1804289383@sybase.com
From: Colin
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Common Table Expression
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f1a7c4.106a.1681692777@sybase.com>
References: <49e5b457@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Apr 2009 04:51:32 -0700
X-Trace: forums-1-dub 1240573892 10.22.241.41 (24 Apr 2009 04:51:32 -0700)
X-Original-Trace: 24 Apr 2009 04:51:32 -0700, 10.22.241.41
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:2031
Article PK: 97630

Ok, thanks for both responses.

Regards,
Colin

> <Colin> wrote in message
> > news:49e485a4.2424.1681692777@sybase.com... 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
>
> 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").
>
>