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.

How About you think of these features

10 posts in Product Futures Discussion Last posting was on 2003-02-07 15:03:29.0Z
wubaozhong Posted on 2002-11-30 18:05:35.0Z
From: "wubaozhong" <wubaozhong@msn.com>
Subject: How About you think of these features
Date: Sun, 1 Dec 2002 02:05:35 +0800
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <gXniGZPmCHA.319@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 218.76.12.249
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:232
Article PK: 93405

I have been using Sybase,Oracle and M$ SQL Server for years,I think Sybase
should implement the following features:
1.Support sub-queries in From clause,eg:Select a.* from (select ...) a where
...(ASA supports this)
2.User defined functions in T-SQL;(I hate using java)( ASA support)
3.Rows level triggers(Also ASA support)
4.Increase performance of Cursors;
5.Increase performance of BLOB types;
6.When new version realesed,take full test on different platforms in
different languages,ASE 12.X does bad jobs especially in non english
languages

I have sent these to sybase,but no reply.


Ilya Zvyagin Posted on 2003-02-07 15:03:29.0Z
Reply-To: "Ilya Zvyagin" <masterziv@mail.ru>
From: "Ilya Zvyagin" <masterziv@mail.ru>
References: <gXniGZPmCHA.319@forums.sybase.com>
Subject: Re: How About you think of these features
Date: Fri, 7 Feb 2003 18:03:29 +0300
Lines: 34
Organization: FCT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
FL-Build: Fidolook Express 2001 UIExt. BuildID: 3BC00FAD (7/10/2001 12:17:49).
X-Comment-To: wubaozhong
Message-ID: <1044630209.220804@gatekeeper.fct.ru>
Cache-Post-Path: gatekeeper.fct.ru!unknown@dream.int.fct.ru
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: gatekeeper.fct.ru 212.113.103.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:165
Article PK: 93341

Hello, wubaozhong!
You wrote on Sun, 1 Dec 2002 02:05:35 +0800:

w> I have been using Sybase,Oracle and M$ SQL Server for years,I think
w> Sybase should implement the following features:
w> 1.Support sub-queries in From clause,eg:Select a.* from (select ...) a
w> where ...(ASA supports this)

I don't think this whould be harmful for ASE but usually only people
with lack of understanding of SQL need subqueries in FROM.
I don't know a query which can not be written without this feature.
But for better compartibility with MSSQL this would be really useful.

w> 2.User defined functions in T-SQL;(I hate using java)( ASA support)
w> 3.Rows level triggers(Also ASA support)

Oh, please, no row-level triggers. You can't program set operations or
cursors ? Then you'd better take a book and study it, but don't spoil a good RDBMS
which ASE is with row-level triggers.

w> 4.Increase performance of Cursors;
w> 5.Increase performance of BLOB types;
w> 6.When new version realesed,take full test on different platforms in
w> different languages,ASE 12.X does bad jobs especially in non english
w> languages

This is too abstract to be a proposal. I ignore.

--------------------
Ilya Zvyagin, First Container Terminal of SPb Sea Port
E-mail: masterziv@*KILLSPAM*mail.ru - include HP in subject
ICQ UID: 29427861(MasterZIV)


KR Posted on 2002-12-01 12:33:55.0Z
Reply-To: "KR" <zzb26@mail.com>
From: "KR" <zzb26@mail.com>
References: <gXniGZPmCHA.319@forums.sybase.com>
Subject: Re: How About you think of these features
Date: Sun, 1 Dec 2002 13:33:55 +0100
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <BGRUbgTmCHA.199@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: m173.net81-65-228.noos.fr 81.65.228.173
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:231
Article PK: 93404

> 1.Support sub-queries in From clause,eg:Select a.* from (select ...) a
where

The difference between DBs that support this select statement and Sybase is
that in Sybase you will first need to select into a tmp table and then query
the tmp table. From a coding perspective, there is little difference. I
think there is a reason why ASE currently does not support this type of
select statement and the reason is that ASE currently uses the allpages
locking on system tables and on long running select .... from ( select
....) statements in a long running transaction would lock up sys tables for
an extended period of time. Once system tables have datarows locking, then
that select statement would be a nice addition.



> 2.User defined functions in T-SQL

Yes, that would be nice! Will ASE 15.0 support this?????



> 3.Rows level triggers(Also ASA support)
Can you be more specific! ASE supports triggers on rows.
Insert/Delete/Update a row and a trigger is fired. Is there a certain
trigger feature that you are thinking of that ASE doesn't support in
triggers???



> 4.Increase performance of Cursors;
Have you noticed other DBs outperform Sybase's implementation of cursors.
What sort of performence differences have you seen? Unfortunately, when
using cursors in client applications, there is a lot of network
communication back and forth that segnificately hurt performence and there
is no way around that.



kr

"wubaozhong" <wubaozhong@msn.com> wrote in message
news:gXniGZPmCHA.319@forums.sybase.com...
> I have been using Sybase,Oracle and M$ SQL Server for years,I think Sybase
> should implement the following features:
> 1.Support sub-queries in From clause,eg:Select a.* from (select ...) a
where
> ...(ASA supports this)
> 2.User defined functions in T-SQL;(I hate using java)( ASA support)
> 3.Rows level triggers(Also ASA support)
> 4.Increase performance of Cursors;
> 5.Increase performance of BLOB types;
> 6.When new version realesed,take full test on different platforms in
> different languages,ASE 12.X does bad jobs especially in non english
> languages
>
> I have sent these to sybase,but no reply.
>
>


Paul Horan[TeamSybase] Posted on 2002-12-02 05:38:31.0Z
From: "Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom>
References: <gXniGZPmCHA.319@forums.sybase.com> <BGRUbgTmCHA.199@forums.sybase.com>
Subject: Re: How About you think of these features
Date: Mon, 2 Dec 2002 00:38:31 -0500
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <kPQ3hdcmCHA.259@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: ny-chicagostreet2c-30.buf.adelphia.net 68.69.67.30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:228
Article PK: 93401

"KR" <zzb26@mail.com> wrote in message
news:BGRUbgTmCHA.199@forums.sybase.com...

<snip>

> > 2.User defined functions in T-SQL
>
> Yes, that would be nice! Will ASE 15.0 support this?????
>

Agreed, wholeheartedly...

>
> > 3.Rows level triggers(Also ASA support)
> Can you be more specific! ASE supports triggers on rows.
> Insert/Delete/Update a row and a trigger is fired. Is there a certain
> trigger feature that you are thinking of that ASE doesn't support in
> triggers???
>
He's referring to Row-level triggers. ASE only supports Statement-level
triggers. In other words, if I delete 10 rows from a table with a single
DELETE statement, a row-level trigger would fire 10 times, once for each
row. In ASE, the trigger fires once, and all 10 rows that were deleted can
be referenced in the DELETED view.
Row-level triggers are much easier to write (IMO).

<snip>

Paul Horan[TeamSybase]
VCI Springfield, MA
www.vcisolutions.com


Jason L. Froebe Posted on 2002-12-30 04:21:03.0Z
From: Jason L. Froebe <jfroebe@froebe.net>
Subject: Re: How About you think of these features
Date: Sun, 29 Dec 2002 22:21:03 -0600
Message-ID: <MPG.187985ae33d9228c98968b@forums.sybase.com>
References: <gXniGZPmCHA.319@forums.sybase.com> <BGRUbgTmCHA.199@forums.sybase.com> <kPQ3hdcmCHA.259@forums.sybase.com>
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 17
NNTP-Posting-Host: 12-247-248-248.client.attbi.com 12.247.248.248
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:207
Article PK: 93382

In article <kPQ3hdcmCHA.259@forums.sybase.com>, "Paul Horan
[TeamSybase]" <paulhATvcisolutionsDOTcom> says...

> "KR" <zzb26@mail.com> wrote in message
> news:BGRUbgTmCHA.199@forums.sybase.com...
>
> <snip>
>
> > > 2.User defined functions in T-SQL
> >
> > Yes, that would be nice! Will ASE 15.0 support this?????
> >
>
> Agreed, wholeheartedly...

AFAIK, no. At present the only method to add a "function" is to use the
Java option which you have to pay extra for. You can test it using a
developer's license (Linux/Win32 only).

jason

--
"You gotta learn to laugh.. it's the way to true love!"

http://jfroebe.bookcrossing.com


Michael Peppler Posted on 2002-12-02 16:13:07.0Z
From: Michael Peppler <mpeppler@peppler.org>
Subject: Re: How About you think of these features
Date: Mon, 02 Dec 2002 08:13:07 -0800
References: <gXniGZPmCHA.319@forums.sybase.com> <BGRUbgTmCHA.199@forums.sybase.com> <kPQ3hdcmCHA.259@forums.sybase.com>
User-Agent: Pan/0.11.3 (Unix)
Mime-Version: 1.0
Content-Type: text/plain; charset=iso885915
Content-Transfer-Encoding: 8bit
X-Comment-To: "Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom>
Message-ID: <mRmbZAimCHA.333@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 36
NNTP-Posting-Host: gw.peppler.org 206.55.243.57
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:226
Article PK: 93400

javax.mail.util.SharedByteArrayInputStream@52863cf9


Paul Horan[TeamSybase] Posted on 2002-12-06 23:42:30.0Z
From: "Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom>
References: <gXniGZPmCHA.319@forums.sybase.com> <BGRUbgTmCHA.199@forums.sybase.com> <kPQ3hdcmCHA.259@forums.sybase.com> <mRmbZAimCHA.333@forums.sybase.com>
Subject: Re: How About you think of these features
Date: Fri, 6 Dec 2002 18:42:30 -0500
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <5gwC$NYnCHA.199@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: ny-chicagostreet2c-30.buf.adelphia.net 68.69.67.30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:223
Article PK: 93398

I've found that 99.9% of relational database developers have no idea how to
"think" in set theory. At least the one's that I've had the good fortune to
work with... <G>

--
Paul Horan[TeamSybase]
VCI Springfield, MA
www.vcisolutions.com

"Michael Peppler" <mpeppler@peppler.org> wrote in message
news:mRmbZAimCHA.333@forums.sybase.com...
> On Sun, 01 Dec 2002 21:38:31 -0800, Paul Horan[TeamSybase] wrote:
>
> > "KR" <zzb26@mail.com> wrote in message
> > news:BGRUbgTmCHA.199@forums.sybase.com...
> >
> > <snip>
> >
> >> > 2.User defined functions in T-SQL
> >>
> >> Yes, that would be nice! Will ASE 15.0 support this?????
> >>
> >>
> > Agreed, wholeheartedly...
> >
> >
> >> > 3.Rows level triggers(Also ASA support)
> >> Can you be more specific! ASE supports triggers on rows.
> >> Insert/Delete/Update a row and a trigger is fired. Is there a certain
> >> trigger feature that you are thinking of that ASE doesn't support in
> >> triggers???
> >>
> > He's referring to Row-level triggers. ASE only supports Statement-level
> > triggers. In other words, if I delete 10 rows from a table with a
> > single DELETE statement, a row-level trigger would fire 10 times, once
> > for each row. In ASE, the trigger fires once, and all 10 rows that were
> > deleted can be referenced in the DELETED view. Row-level triggers are
> > much easier to write (IMO).
>
> They are easier to write if you are not applying set theory.
> But they will be slower to run, unless you use cursors in the trigger.
> But then again one *should* be able to avoid cursors in most cases.
>
> Michael
> --
> Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
> mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
> ZetaTools: Call perl functions as Sybase stored procedures!


Anthony Mandic Posted on 2002-12-07 02:35:47.0Z
Message-ID: <3DF15E83.6042C469@start.com.au>
Date: Sat, 07 Dec 2002 13:35:47 +1100
From: Anthony Mandic <am_is_not@start.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Re: How About you think of these features
References: <gXniGZPmCHA.319@forums.sybase.com> <BGRUbgTmCHA.199@forums.sybase.com> <kPQ3hdcmCHA.259@forums.sybase.com> <mRmbZAimCHA.333@forums.sybase.com> <5gwC$NYnCHA.199@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 8
NNTP-Posting-Host: 203-109-142-9.static.ihug.com.au 203.109.142.9
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:222
Article PK: 93396


"Paul Horan[TeamSybase]" wrote:
>
> I've found that 99.9% of relational database developers have no idea how to
> "think" in set theory. At least the one's that I've had the good fortune to
> work with... <G>

Only 99.9%? You should consider yourself lucky.

-am © 2002


Bret Halford Posted on 2002-12-01 17:59:54.0Z
Message-ID: <3DEA4E1A.693B9465@sybase.com>
Date: Sun, 01 Dec 2002 10:59:54 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: How About you think of these features
References: <gXniGZPmCHA.319@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.ase.product_futures_discussion
Lines: 14
NNTP-Posting-Host: 10.22.120.56
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:229
Article PK: 93406


wubaozhong wrote:
>
> I have been using Sybase,Oracle and M$ SQL Server for years,I think Sybase
> should implement the following features:
> 1.Support sub-queries in From clause,eg:Select a.* from (select ...) a where
> ...(ASA supports this)

This is known as a "derived table" or "inline view"; such a feature
is slated for the 12.6 ASE release under CR 203737.


> 3.Rows level triggers(Also ASA support)

There is an open feature request for this, CR 129680, but I'm not aware
of any current plans to implement it.


wubaozhong Posted on 2002-12-03 05:28:43.0Z
From: "wubaozhong" <wubaozhong@msn.com>
References: <gXniGZPmCHA.319@forums.sybase.com> <3DEA4E1A.693B9465@sybase.com>
Subject: Re: How About you think of these features
Date: Tue, 3 Dec 2002 13:28:43 +0800
Lines: 3
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <Xnjax8omCHA.198@forums.sybase.com>
Newsgroups: sybase.public.ase.product_futures_discussion
NNTP-Posting-Host: 218.76.164.68
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:225
Article PK: 93397

thank you all for reply