What version of the SQL-standard does SQL Anywhere 16 support? |
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:
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:
Furthermore, you can use the SQLFLAGGER() builtin function to check individual statements against several SQL standard versions. 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
|