Keywords Returned in IDBInfo::GetKeywords

In OLE DB, the data source object has an interface called IDBInfo, one of whose methods is IDBInfo::GetKeywords. This method returns all the keywords that apply to a provider. When a keyword is used in a query, it must be quoted. A consumer can use the list of keywords returned by this method to decide which identifier needs to be quoted.

Note   It is a good practice to quote all identifiers in an MDX expression, regardless of whether they are keywords. _UNIQUE_NAME values retrieved from a schema rowset are already quoted, so there is no need to quote them again.

MDX introduces new keywords. Any provider that declares itself to be an MDP (in the sources rowset returned by ISourcesRowset::GetSourcesRowset) must return at least the following list in IDBInfo::GetKeywords:

• AND
  
  
• AS
  
  
• AXIS
  
  
• BACK_COLOR
  
  
• CASE
  
  
• CATALOG_NAME
  
  
• CELL
  
  
• CELL_ORDINAL
  
  
• CHAPTERS
  
  
• CHILDREN
  
  
• CHILDREN_CARDINALITY
  
  
• COALESCEEMPTY
  
  
• COLUMNS
  
  
• CUBE
  
  
• CUBE_NAME
  
  
• CURRENTMEMBER
  
  
• DEFAULTMEMBER
  
  
• DESCRIPTION
  
  
• DIMENSION
  
  
• DIMENSION_UNIQUE_NAME
  
  
• ELSE
  
  
• EMPTY
  
  
• END
  
  
• FIRSTCHILD
  
  
• FIRSTSIBLING
  
  
• FONT_FLAGS
  
  
• FONT_NAME
  
  
• FONT_SIZE
  
  
• FORE_COLOR
  
  
• FORMAT_STRING
  
  
• FORMATTED_VALUE
  
  
• FROM
  
  
• HIERARCHY_UNIQUE_NAME
  
  
• IIF
  
  
• ISEMPTY
  
  
• ITEM
  
  
• LASTCHILD
  
  
• LASTSIBLING
  
  
• LEVEL_UNIQUE_NAME
  
  
• LEVELS
  
  
• MEMBER
  
  
• MEMBER_CAPTION
  
  
• MEMBER_GUID
  
  
• MEMBER_NAME
  
  
• MEMBER_ORDINAL
  
  
• MEMBER_TYPE
  
  
• MEMBER_UNIQUE_NAME
  
  
• MEMBERS
  
  
• NEXTMEMBER
  
  
• NON
  
  
• NOT
  
  
• ON
  
  
• OR
  
  
• PAGES
  
  
• PARENT
  
  
• PARENT_LEVEL
  
  
• PARENT_UNIQUE_NAME
  
  
• PREVMEMBER
  
  
• PROPERTIES
  
  
• REFRESH
  
  
• ROWS
  
  
• SCHEMA_NAME
  
  
• SECTIONS
  
  
• SELECT
  
  
• SET
  
  
• SOLVE_ORDER
  
  
• VALUE
  
  
• WHEN
  
  
• WHERE
  
  
• WITH
  
  
• XOR

If the provider declares itself to be a TDP also, it has to return (in addition to the above list), a list of the keywords listed in the OLE DB Programmer’s Reference.