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.

ISO/ANSI Standard

5 posts in General Discussion Last posting was on 2012-11-30 11:33:53.0Z
M.Karthikeyan Posted on 2012-11-29 08:28:51.0Z
Sender: 3beb.50b71be3.1804289383@sybase.com
From: M.KARTHIKEYAN
Newsgroups: sybase.public.ase.general
Subject: ISO/ANSI Standard
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50b71cc3.3c33.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 Nov 2012 00:28:51 -0800
X-Trace: forums-1-dub 1354177731 172.20.134.41 (29 Nov 2012 00:28:51 -0800)
X-Original-Trace: 29 Nov 2012 00:28:51 -0800, 172.20.134.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31552
Article PK: 74441

Hi,

I would like to which ISO/ANSI SQL Standard does sybase
follow?

SQL 2003
SQL 2006
SQL 2008

or SQL-92 ?


Bret Halford Posted on 2012-11-29 15:02:22.0Z
From: Bret Halford <bret.halford@sap.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121026 Thunderbird/16.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ISO/ANSI Standard
References: <50b71cc3.3c33.1681692777@sybase.com>
In-Reply-To: <50b71cc3.3c33.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50b778fe@forums-1-dub>
Date: 29 Nov 2012 07:02:22 -0800
X-Trace: forums-1-dub 1354201342 172.20.134.152 (29 Nov 2012 07:02:22 -0800)
X-Original-Trace: 29 Nov 2012 07:02:22 -0800, vip152.sybase.com
Lines: 75
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31556
Article PK: 74445


On 11/29/2012 1:28 AM, M.KARTHIKEYAN wrote:
> Hi,
>
> I would like to which ISO/ANSI SQL Standard does sybase
> follow?
>
> SQL 2003
> SQL 2006
> SQL 2008
>
> or SQL-92 ?
>

The documentation in previous versions of ASE stated
SQL-92 entry-level compliance, though that wording did
drop out of the current version's documents.

At a very high level, you might consider the answer SQL-92 with
a large number of features from more recent standards and
other extensions.

For a far more precise answer, I found the following...

Earlier this year another customer asked
"Please advise if ASE 12.54 and 15.7 comply to ansi standards
SQL-92,SQL-99,SQL-2003, and SQL-2008"

The answer from an engineer from our language group was:

-----------------------------------
There is not a simple answer; moreover the question is far from simple
as well.

The current, official ISO SQL standard is SQL-2011. The others listed are
obsolete, and other than historical information it really doesn't matter
the level to which a database product conforms to the older standards.
Indeed, there are aspects of the various standards over the years that are
contradictory; for example, SQL/99 introduced the VARBIT data type, the
SQL/2003 standard removed it.

There are also "core" features of the standard, and "optional" features. An
official statement of compliance with respect to the ISO SQL standard
pertains to the "core" features only; implementations are free to pick and
choose which of the optional features they support. To pick an example, the
support for SEQUENCE types is feature T176. The "core" and "optional"
subsets were introduced with SQL/99. In SQL/92, the SQL standard was
levelled into three "parts" or feature subsets (entry, intermediate, and
full), but even though SQL/92 was considered "large" at the time, it has
only a fraction of the constructions included in the SQL/2011 standard. So
again, it's not clear from the question what specific compliance the client
is asking.

After all that, there is still the issue of the degree of compliance. I
know of no product that can truthfully claim 100% compliance to SQL/2011
core, or for that matter I am unaware of any implementation that
historically matched 100% of a standard at a particular time. All SQL
products have legacy features which may or may not match a particular
standard. A good example is ASE's T-SQL language, which for stored
procedures is non-compliant because the standard mandates the use of
semicolons as statement delimiters.

The SQL/2011 standard is made up of seven parts and totals almost 3000
pages. There is no longer a compliance suite (one was previously supplied
by the US National Institute of Standards (NIST), part of the US Department
of Commerce) so with a language of that size, any test of compliance is
very difficult to conjure or assess. That said, virtually all commercial
products claim "some level" of compliance with the standard, but "some
level" is never quantified. "
------------------------------------------


I hope that helps.
Cheers,
-bret


M.Karthikeyan Posted on 2012-11-29 08:38:12.0Z
Sender: 3beb.50b71be3.1804289383@sybase.com
From: M.KARTHIKEYAN
Newsgroups: sybase.public.ase.general
Subject: Re: ISO/ANSI Standard
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50b71ef4.3cad.1681692777@sybase.com>
References: <50b71cc3.3c33.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 Nov 2012 00:38:12 -0800
X-Trace: forums-1-dub 1354178292 172.20.134.41 (29 Nov 2012 00:38:12 -0800)
X-Original-Trace: 29 Nov 2012 00:38:12 -0800, 172.20.134.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31553
Article PK: 74447

I think Sybase follows ISO/ANSI 2008 standard. If yes, why
Sybase is not supporting windows functions like over(),
row_number() , rank() etc., in 15.5 or later ?

Also..why SAP is not concentrating on developing some good
tool for sybase? I have recently saw a tool called
"SqlQueryStress". It looks good to get all the performance
related information.

Don't say set statistics io will do that..my question is ...
why SAP or Sybase didn't develop any tool after "Sql
Advantage" ?

> Hi,
>
> I would like to which ISO/ANSI SQL Standard does sybase
> follow?
>
> SQL 2003
> SQL 2006
> SQL 2008
>
> or SQL-92 ?


M.Karthikeyan Posted on 2012-11-30 05:49:16.0Z
Sender: 40c3.50b72e36.1804289383@sybase.com
From: M.Karthikeyan
Newsgroups: sybase.public.ase.general
Subject: Re: ISO/ANSI Standard
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50b848dc.6fc.1681692777@sybase.com>
References: <50b71ef4.3cad.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 Nov 2012 21:49:16 -0800
X-Trace: forums-1-dub 1354254556 172.20.134.41 (29 Nov 2012 21:49:16 -0800)
X-Original-Trace: 29 Nov 2012 21:49:16 -0800, 172.20.134.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31562
Article PK: 74452

any inputs?

> I think Sybase follows ISO/ANSI 2008 standard. If yes, why
> Sybase is not supporting windows functions like over(),
> row_number() , rank() etc., in 15.5 or later ?
>
> Also..why SAP is not concentrating on developing some good
> tool for sybase? I have recently saw a tool called
> "SqlQueryStress". It looks good to get all the performance
> related information.
>
> Don't say set statistics io will do that..my question is
> .. why SAP or Sybase didn't develop any tool after "Sql
> Advantage" ?
>
> > Hi,
> >
> > I would like to which ISO/ANSI SQL Standard does sybase
> > follow?
> >
> > SQL 2003
> > SQL 2006
> > SQL 2008
> >
> > or SQL-92 ?


Rob V Posted on 2012-11-30 11:33:53.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ISO/ANSI Standard
References: <50b71ef4.3cad.1681692777@sybase.com> <50b848dc.6fc.1681692777@sybase.com>
In-Reply-To: <50b848dc.6fc.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50b899a1$1@forums-1-dub>
Date: 30 Nov 2012 03:33:53 -0800
X-Trace: forums-1-dub 1354275233 172.20.134.152 (30 Nov 2012 03:33:53 -0800)
X-Original-Trace: 30 Nov 2012 03:33:53 -0800, vip152.sybase.com
Lines: 35
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31568
Article PK: 74458

I think Bret Halford's reply is as complete as it can get. Bottom line:
"compliant" is a relative concept and there is no simple yes or no when
it comes to ANSI standard compliance.

Rob V.

On 30-Nov-2012 06:49, M.Karthikeyan wrote:
> any inputs?
>
>> I think Sybase follows ISO/ANSI 2008 standard. If yes, why
>> Sybase is not supporting windows functions like over(),
>> row_number() , rank() etc., in 15.5 or later ?
>>
>> Also..why SAP is not concentrating on developing some good
>> tool for sybase? I have recently saw a tool called
>> "SqlQueryStress". It looks good to get all the performance
>> related information.
>>
>> Don't say set statistics io will do that..my question is
>> .. why SAP or Sybase didn't develop any tool after "Sql
>> Advantage" ?
>>
>>> Hi,
>>>
>>> I would like to which ISO/ANSI SQL Standard does sybase
>>> follow?
>>>
>>> SQL 2003
>>> SQL 2006
>>> SQL 2008
>>>
>>> or SQL-92 ?