syntax highlighting for sql: "Capability" is keyword

[Paul]

Why is "Capability" a key word? I haven't been able to find
evidence that it is a key word in an SQL dialect.

[David Fishburn]

On Sun, Sep 6, 2015 at 7:48 PM, Paul <Paul.D...@gmail.com> wrote:

Why is "Capability" a key word?  I haven't been able to find
evidence that it is a key word in an SQL dialect.

What SQL database are you coding for?

What SQL dialect are you using in Vim (the default is for Oracle).

You can check running:
:SQLGetType

You can change the SQL dialect on a per buffer by running 

:SQLSetType (then use the tab key to cycle through available dialects)

HTH,

David

[Paul]

David Fishburn <dfishburn.vim <at> gmail.com> writes:
>On Sun, Sep 6, 2015 at 7:48 PM, Paul <Paul.Domaskis <at> gmail.com>

>wrote:
>> Why is "Capability" a key word? I haven't been able to find
>> evidence that it is a key word in an SQL dialect.
>
> What SQL database are you coding for?
>
> What SQL dialect are you using in Vim (the default is for Oracle).
> You can check running::SQLGetType
>
> You can change the SQL dialect on a per buffer by running
> :SQLSetType (then use the tab key to cycle through available
> dialects)

I'm coding for MS Access with SQL-92 support enabled. However, I
posted the question not so much about my specific situation, but
rather, why a simple web search seems to unearth no evidence of
Capability being a keyword in any dialect. Though it's not of direct
relevance to the question, here's my setup:

:SQLGetType
Current SQL dialect in use:sqlanywhere

[David Fishburn]

I'm coding for MS Access with SQL-92 support enabled.  However, I
posted the question not so much about my specific situation, but
rather, why a simple web search seems to unearth no evidence of
Capability being a keyword in any dialect.  Though it's not of direct
relevance to the question, here's my setup:

   :SQLGetType
   Current SQL dialect in use:sqlanywhere

This is why that is a keyword.

ALTER SERVER statement

Modifies the attributes of a remote server.

Syntax

• Alter a remote server

  ALTER [ REMOTE ] SERVER server-name
  [ CLASS server-class | variable ]
  [ USING connection-string-info | variable ]
  [ CAPABILITY cap-name { ON | OFF | VALUE variable } ]
  [ READ ONLY [ ON | OFF | VALUE variable ] ]
  [ DEFAULT LOGIN string | variable [ IDENTIFIED BY string | variable ]  | NO DEFAULT LOGIN ]

http://dcx.sap.com/index.html#sqla170/en/html/81698c796ce2101485d3e319d7e333a1.html

HTH,

David

[Paul]

David Fishburn <dfishburn.vim <at> gmail.com> writes:
>

> This is why that is a keyword.
>
>
> ALTER SERVER statement
>
> Modifies the attributes of a remote server.
>
> Syntax
> Alter a remote server
> ALTER [ REMOTE ] SERVER server-name
> [ CLASS server-class | variable ]
> [ USING connection-string-info | variable ]
> [ CAPABILITY cap-name { ON | OFF | VALUE variable } ]
> [ READ ONLY [ ON | OFF | VALUE variable ] ]
> [ DEFAULT LOGIN string | variable [ IDENTIFIED BY string | variable ] |
NO DEFAULT LOGIN ]
>
>
http://dcx.sap.com/index.html#sqla170/en/html/81698c796ce2101485d3e319d7e333
a1.html

Ah. Mystery solved. Thanks, David.