when I type dbcc cis(showcaps, SERVERNAME)
I see the list of capabilities supported by SERVERNAME, and
their values.

Unfortunately, I have been unable to determine what those
values actually correspond to.

For example, capability 102 is "join handling" the
documentation *I* could find says that
0=Unsupported
1=No outer join supported
2=T-SQL support
3=Oracle supported

yet if I connect to an ASE server, it tells me that the
value is "6". 6? what does that mean....
Similarly, the values 101-147. What does the CapValue
actually correspond to?

In most cases, 0 is not enabled, 1 is enabled, but obviously
there are other values as well.

Does anyone know? Thanks

Geoff G wrote:
This question might be better asked of Sybase Tech Support.
And, by all means, if you do find out, please post a reply
here so that it can be archived for future reference.

-am © 2007

Usually these capability values are fixed for a certain remote backend and
won't need to be changed at all.

The value 6 in cap 102 means it supports TSQL and ANSI joins.

<Geoff G> wrote