Export (0) Print
Expand All

OleDbLiteral Enumeration

Returns information about literals used in text commands, data values, and database objects.

[Visual Basic]
<Serializable>
Public Enum OleDbLiteral
[C#]
[Serializable]
public enum OleDbLiteral
[C++]
[Serializable]
__value public enum OleDbLiteral
[JScript]
public
   Serializable
enum OleDbLiteral

Remarks

The OleDbLiteral enumeration returns the following categories of literal information.

Category Returns
A special character or characters used by text commands, such as the character used to quote identifiers. The character or characters.
A literal data value, such as a character literal in an SQL statement. The maximum length of the literal in characters, a list of the characters that cannot be used in the literal, and a list of the characters that cannot be used as the first character of the literal.
The name of a database object such as a column or table. The maximum length of the name in characters, a list of the characters that cannot be used in the name, and a list of the characters that cannot be used as the first character of the name.
Multidimensional restriction columns. Restriction values that return information about cubes, dimensions, hierarchies, levels, and members available from a data source; and are treated as literals instead of as search patterns.

Most members of the OleDbLiteral enumeration maps to one of the OLE DB DBLITERAL values that are returned in the DBLITERALINFO structure.

Multidimensional restriction columns are members of schema objects and map to OLE DB for OLAP used by the IDBSchemaRowset interface. For more information, see "OLE DB for OLAP Concepts" in the OLE DB Programmer's Reference.

A NotSupportedException is generated if the specified literal information is not supported and cannot be returned.

Members

Member name Description
Binary_Literal A binary literal in a text command. Binary_Literal maps to DBLITERAL_BINARY_LITERAL.
Catalog_Name A catalog name in a text command. Catalog_Name maps to DBLITERAL_CATALOG_NAME.
Catalog_Separator The character that separates the catalog name from the rest of the identifier in a text command. Catalog_Separator maps to DBLITERAL_CATALOG_SEPARATOR.
Char_Literal A character literal in a text command. Char_Literal maps to DBLITERAL_CHAR_LITERAL.
Column_Alias A column alias in a text command. Column_Alias maps to DBLITERAL_COLUMN_ALIAS.
Column_Name A column name used in a text command or in a data-definition interface. Column_Name maps to DBLITERAL_COLUMN_NAME.
Correlation_Name A correlation name (table alias) in a text command. Correlation_Name maps to DBLITERAL_CORRELATION_NAME.
Cube_Name The name of a cube in a schema (or the catalog if the provider does not support schemas).
Cursor_Name A cursor name in a text command. Cursor_Name maps to DBLITERAL_CURSOR_NAME.
Dimension_Name The name of the dimension. If a dimension is part of more than one cube, there is one row for each cube/dimension combination.
Escape_Percent_Prefix The character used in a LIKE clause to escape the character returned for the DBLITERAL_LIKE_PERCENT literal. For example, if a percent sign (%) is used to match zero or more characters and this is a backslash (\), the characters "abc\%%" match all character values that start with "abc%". Some SQL dialects support a clause (the ESCAPE clause) that can be used to override this value. Escape_Percent_Prefix maps to DBLITERAL_ESCAPE_PERCENT_PREFIX.
Escape_Percent_Suffix The escape character, if any, used to suffix the character returned for the DBLITERAL_LIKE_PERCENT literal. For example, if a percent sign (%) is used to match zero or more characters and percent signs are escaped by enclosing in open and close square brackets, DBLITERAL_ESCAPE_PERCENT_PREFIX is "[", DBLITERAL_ESCAPE_PERCENT_SUFFIX is "]", and the characters "abc[%]%" match all character values that start with "abc%". Providers that do not use a suffix character to escape the DBLITERAL_ESCAPE_PERCENT character do not return this literal value and can set the lt member of the DBLITERAL structure to DBLITERAL_INVALID if requested. Escape_Percent_Suffix maps to DBLITERAL_ESCAPE_PERCENT_SUFFIX.
Escape_Underscore_Prefix The character used in a LIKE clause to escape the character returned for the DBLITERAL_LIKE_UNDERSCORE literal. For example, if an underscore (_) is used to match exactly one character and this is a backslash (\), the characters "abc\_ _" match all character values that are five characters long and start with "abc_". Some SQL dialects support a clause (the ESCAPE clause) that can be used to override this value. Escape_Underscore_Prefix maps to DBLITERAL_ESCAPE_UNDERSCORE_PREFIX.
Escape_Underscore_Suffix The character used in a LIKE clause to escape the character returned for the DBLITERAL_LIKE_UNDERSCORE literal. For example, if an underscore (_) is used to match exactly one character and this is a backslash (\), the characters "abc\_ _" match all character values that are five characters long and start with "abc_". Some SQL dialects support a clause (the ESCAPE clause) that can be used to override this value. Escape_Underscore_Suffix maps to DBLITERAL_ESCAPE_UNDERSCORE_SUFFIX.
Hierarchy_Name The name of the hierarchy. If the dimension does not contain a hierarchy or has only one hierarchy, the current column contains a null value.
Index_Name An index name used in a text command or in a data-definition interface. Index_Name maps to DBLITERAL_INDEX_NAME.
Invalid An invalid value. Invalid maps to DBLITERAL_INVALID.
Level_Name Name of the cube to which the current level belongs.
Like_Percent The character used in a LIKE clause to match zero or more characters. For example, if this is a percent sign (%), the characters "abc%" match all character values that start with "abc". Like_Percent maps to DBLITERAL_LIKE_PERCENT.
Like_Underscore The character used in a LIKE clause to match exactly one character. For example, if this is an underscore (_), the characters "abc_" match all character values that are four characters long and start with "abc". Like_Underscore maps to DBLITERAL_LIKE_UNDERSCORE.
Member_Name The name of the member.
Procedure_Name A procedure name in a text command. Procedure_Name maps to DBLITERAL_PROCEDURE_NAME.
Property_Name The name of the property.
Quote_Prefix The character used in a text command as the opening quote for quoting identifiers that contain special characters. Quote_Prefix maps to DBLITERAL_QUOTE_PREFIX.
Quote_Suffix The character used in a text command as the closing quote for quoting identifiers that contain special characters. 1.x providers that use the same character as the prefix and suffix may not return this literal value and can set the lt member of the DBLITERAL structure to DBLITERAL_INVALID if requested. Quote_Suffix maps to DBLITERAL_QUOTE_SUFFIX.
Schema_Name A schema name in a text command. Schema_Name maps to DBLITERAL_SCHEMA_NAME.
Schema_Separator The character that separates the schema name from the rest of the identifier in a text command. Schema_Separator maps to DBLITERAL_SCHEMA_SEPARATOR.
Table_Name A table name used in a text command or in a data-definition interface. Table_Name maps to DBLITERAL_TABLE_NAME.
Text_Command A text command, such as an SQL statement. Text_Command maps to DBLITERAL_TEXT_COMMAND.
User_Name A user name in a text command. User_Name maps to DBLITERAL_USER_NAME.
View_Name A view name in a text command. View_Name maps to DBLITERAL_VIEW_NAME.

Requirements

Namespace: System.Data.OleDb

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Assembly: System.Data (in System.Data.dll)

See Also

System.Data.OleDb Namespace

Show:
© 2014 Microsoft