What version of the SQL-standard does SQL Anywhere 16 support?

asked 15 Oct '13, 03:18

M%20G's gravatar image

M G
629253044
accept rate: 42%

edited 15 Oct '13, 03:21


I guess there is no short answer to that question, as the SQL standard is such a huge collection of obligatory and optional features. The general rule can be found in the SQL dialects and compatibility topic:

SQL Anywhere complies with the SQL-92-based United States Federal Information Processing Standard Publication (FIPS PUB) 127. With minor exceptions, SQL Anywhere is compliant with the ISO/ANSI SQL/2008 core specification as documented in the 9 parts of ISO/IEC JTC 1/SC 32 9075-2008. Information about compliance is provided in the reference documentation for each feature of SQL Anywhere.

That is, for each SQL Anywhere statement, you will find a "Standards and compatibility" section describing whether and in what degree the statement fits the SQL/2008 standard, cf. here for the SELECT statement:

SQL/2008 Core feature. The complexity of the SELECT statement means that you should check individual clauses against the standard. For example, the ROLLUP keyword, which can be specified in a GROUP BY clause, is part of optional SQL/2008 language feature T431. Some of the SQL/2008 optional language features supported by SQL Anywhere include:

  • The WINDOW clause and WINDOW aggregate functions comprise optional SQL/2008 language features T611 and T612.
  • Sequence expressions are part of feature T176.
    ...

Furthermore, you can use the SQLFLAGGER() builtin function to check individual statements against several SQL standard versions.

permanent link

answered 15 Oct '13, 03:45

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

edited 15 Oct '13, 09:06

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050

1

Ok thank you for your response, Well it seems like both SQL Anywhere 16 and SQL Anywhere 12 support this, but somehow I thought SQL Anywhere 12 only supported SQL/2003, but I guess I was misstaken...

(18 Oct '13, 05:50) M G
Replies hidden

Yes, v12 was released in 2010, so it apparently could take that SQL standard version into account, whereas v10 and v11 relate to SQL/2003.

(18 Oct '13, 06:24) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×90
×5

question asked: 15 Oct '13, 03:18

question was seen: 2,315 times

last updated: 18 Oct '13, 06:24