As Karim has explained here, the default server capabilities for a particular server class are based on the oldest supported version of the according DBMS.
For example, for Microsoft SQL Server that is version 6.5, Service Pack 4 - released around 1998, methinks.
That's alright with me.
However, as these versions are often really old, it would be nice if SQL Anywhere could provide information for the default capabilities of newer versions. - I don't expect different server classes but would think of a document with capabilities that could be set for newer versions (or a bunch of scripts to update them?).
At the moment, one is somewhat on his own to find out whether a particular version might support more than the default capabilities, and that's a risky task not everyone likes to do. But relying on the defaults of an old version will often prevent efficient remote access and lead to unnecessary local computations.
I feel a somewhat "official" list would make updating the capabilities much more easy.
asked 10 Feb '11, 15:06
You are correct. It has been some time since the default capability bits for the various SA remote servers has been updated. And as you pointed out, in addition to the bit settings being somewhat out of date, the list of capability bits and their meanings is not documented very well. I will open two enhancement requests to:
1) revisit the default settings for the various remote servers and get the settings updated to reflect the current set of released versions for each remote server class
2) get the set of capability bits, their meanings and their default setting properly documented.
answered 10 Feb '11, 15:30