Options for the ECDA Option for ODBC and SQL.
SQL Option |
Description |
---|---|
SQL_Accessible_Procedures |
User can execute all procedures returned by sp_stored_procedures. |
SQL_Accessible_Tables |
User is guaranteed SELECT privileges to tables returned by sp_tables. |
SQL_Active_Connections |
No known limit to the number of connections. |
SQL_Active_Statements |
No known limit to the number of statements for a connection. |
SQL_Alter_Table |
Bitmask indicating which clauses in ALTER TABLE are supported. |
SQL_Bookmark_Persistence |
Bitmask enumerating through which bookmarks persist. None supported. |
SQL_Column_Alias |
Support for column alias. |
SQL_Concat_Null_Behavior |
Bitmask indicating how the DBMS handles concatenations with NULL. |
SQL_Convert_Bigint SQL_Convert_Binary SQL_Convert_Bit SQL_Convert_Char SQL_Convert_Date SQL_Convert_Decimal SQL_Convert_Double SQL_Convert_Float SQL_Convert_Integer SQL_Convert_Longvarbinary SQL_Convert_Longvarchar SQL_Convert_Numeric SQL_Convert_Real SQL_Convert_Smallint SQL_Convert_Time SQL_Convert_Timestamp SQL_Convert_Tinyint SQL_Convert_Varbinary SQL_Convert_Varchar |
Bitmask indicating conversions “to type” supported. |
SQL_Convert_Functions |
Bitmask indicating conversion functions supported. |
SQL_Correlation_Name |
Table correlation names supported. |
SQL_CSP_Support |
Sybase/Intersolv extension for supporting CSPs. Value = 16383. |
SQL_Cursor_Commit_Behavior |
Bitmask indicating how a commit operation affects a cursor. |
SQL_Cursor_Rollback_Behavior |
Bitmask indicating how a rollback operation affects a cursor. |
SQL_Cursor_Sensitivity |
A value indicating support for cursor sensitivity. |
SQL_Database_Name |
Value provided by the DirectConnect server. |
SQL_Date_Source_Read_Only |
The datasource is read/write. |
SQL_DBMS_Name |
The target DBMS name. A maximum of 30 characters is returned. |
SQL_DBMS_Ver |
The target DBMS version in the form ##.##.####. A maximum of 30 characters is returned. The version string may have target-specific information that follows. |
SQL_Default_TXN_Isolation |
Bitmask indicating the default transaction level supported by the DBMS. |
SQL_Dynamic_Cursor_Attributes1 |
Bitmask that describes the attributes of a dynamic cursor that are supported by the driver (1st subset of attributes.) |
SQL_Dynamic_Cursor_Attributes2 |
Bitmask that diatribes the attributes of a dynamic cursor that are supported by the driver (2nd subset of attributes.) |
SQL_Expressions_In_Orderby |
Support for expressions in order by clause. |
SQL_Fetch_Direction |
Bitmask enumerating supported options. |
SQL_File_Usage |
Files treated in datasource. |
SQL_Forward_Only_Cursor_Attributes1 |
A bitmask that describes the attributes of a forward-only cursor that are supported by the driver (1st subset of attributes.) |
SQL_Forward_Only_Cursor_Attributes2 |
A bitmask that describes the attributes of a forward-only cursor that are supported by the driver (2nd subset of attributes.) |
SQL_Getdata_Extensions |
Bitmask enumerating extensions to SQLGetData. |
SQL_Group_By |
Bitmask indicating the relationship between GROUP BY columns supported in the DBMS. |
ICD_Cursor_Support |
Bitmask indicating cursor support. |
ICD_Dynamic_Support |
Bitmask indicating dynamic statement support. |
ICD_Execdirect |
Bitmask indicating how dynamic execdirect statement is supported. |
ICD_Language_Support |
Bitmask indicating language statement support. No parameter marker support. |
ICD_Longtypes_Supported |
Support for long types as parameters. |
ICD_Modify_Groupby |
Intersolv driver insures GROUP BY clause when aggregate functions are used as part of the select list. |
SQL_Identifier_Case |
Defines whether identifiers are case-sensitive. |
SQL_Identifier_Quote_Char |
Character used to delimit quoted identifiers. |
SQL_Keywords |
See the Microsoft ODBC 3.5 Programmer’s Reference and SDK Guide for information. |
SQL_Like_Escape_Clause |
Support of “%” character and “_” character as escape characters in like clause. |
SQL_Lock_Types |
Bitmask enumerating supported lock types. |
SQL_Max_Binary_Literal_Len |
Maximum length of binary literal is either unknown or unlimited. |
SQL_Max_Char_Literal_Len |
Maximum length of character literal is either unknown or unlimited. |
SQL_Max_Column_Name_Len |
Maximum length for a column name. Convert this string to an integer. A value of 0 means not supported. |
SQL_Max_Columns_In_Group_By |
Maximum number of columns allowed in SQL GROUP BY clause. Convert this string to an integer. A value of 0 means that the limit is unknown or unlimited. |
SQL_Max_Columns_In_Index |
Maximum number of columns allowed in a SQL CREATE INDEX. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_Columns_In_Order_By |
Maximum number of columns allowed in a SQL ORDER BY clause. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_Columns_In_Select |
Maximum number of columns allowed in a SQL SELECT column list. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_Columns_In_Table |
Maximum number of columns allowed in a SQL CREATE TABLEE. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_Cursor_Name_Len |
Maximum length for a cursor name. Convert this string to an integer. A value of 0 means not supported. |
SQL_Max_Index_Size |
Maximum number of characters allowed in the combined column length of an index. Convert this string to an integer. A value of 0 indicates that the limit is unknown. |
SQL_Max_Identifier_Len |
Maximum size in characters that the datasource supports for user-defined names. |
SQL_Max_Owner_Name_Len |
Maximum length for an owner name. Convert this string to an integer. A value of 0 means not supported. |
SQL_Max_Procedure_Name_Len |
Maximum length for a procedure name. Convert this string to an integer. A value of 0 means not supported |
SQL_Max_Qualifier_Name_Len |
Maximum length for a qualifier name. Convert this string to an integer. A value of 0 means not supported. |
SQL_Max_Row_Size |
Maximum number of characters allowed in the combined column length of a row in a table. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_Row_Size_Includes_Long |
Includes the length of all long datatypes. |
SQL_Max_Statement_Len |
Maximum length allowed for a SQL statement. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_Table_Name_Len |
Maximum length allowed for a table name. Convert this string to an integer. A value of 0 means not supported. |
SQL_Max_Tables_In_Select |
Maximum number of columns allowed in a SQL SELECT FROM clause. Convert this string to an integer. A value of 0 means that the limit is unknown. |
SQL_Max_User_Name_Len |
Maximum length for the user name. Convert this string to an integer. A value of 0 means not supported. |
SQL_Mult_Result_Sets |
Driver does not support multiple result sets in a given language event. |
SQL_Multiple_Active_TXN |
Only one connection can have an active transaction. |
SQL_Need_Long_Data_Len |
Need the length of the long datatypes. |
SQL_Non_Nullable_Columns |
Bitmask indicating whether the DBMS supports non-nullable columns. |
SQL_Null_Collation |
Bitmask indicating how the DBMS collates NULL values. |
SQL_Numeric_Functions |
Bitmask indicating the supported scalar numeric functions. |
SQL_ODBC_API_Conformance |
Bitmask enumerating ODBC level. |
SQL_ODBC_SAG_CLI_Conformance |
Bitmask enumerating compliance to functions of the SAG specification. |
SQL_ODBC_SQL_Conformance |
Bitmask indicating supported SQL grammar. |
SQL_ODBC_SQL_Opt_IEF |
Support for Integrity Enhancement Facility (IEF). |
SQL_Order_By_Columns_In_Select |
Columns in ORDER BY clause must be in select list. |
SQL_OJ_Capabilities |
A bitmask enumerating the types of outer joins supported by the driver and datasource. |
SQL_Outer_Joins |
Support for outer joins. |
SQL_Owner_Term |
The DBMS term for an owner name. A maximum of 30 characters is returned. A null value means not supported. |
SQL_Owner_Usage |
Bitmask indicating statements in which owners can be used. |
SQL_Pos_Operations |
Bitmask enumerating the operations in SQLSetPos. |
SQL_Positioned_Statements |
Bitmask indicating supported positioned SQL statements. |
SQL_Procedure_Term |
DBMS term for a procedure name. A maximum of 30 characters is returned. A null value means not supported. |
SQL_Procedures |
Support for procedures. |
SQL_Qualifier_Location |
Bitmask indicating the position of the qualifier in a qualified table name. |
SQL_Qualifier_Name_Separator |
Character or string separator between the qualifier and the name element. A maximum of five characters is returned. |
SQL_Qualifier_Term |
DBMS term for a qualifier name. A maximum of 30 characters is returned. |
SQL_Qualifier_Usage |
Bitmask indicating in which statements a qualifier can be used. |
SQL_Quoted_Identifier_Case |
Bitmask describing SQL identifier case and storage in system tables when used in SQL statements. |
SQL_Row_Updates |
See the Microsoft ODBC 3.5 Programmer’s Reference and SDK Guide for information. |
SQL_Scroll_Concurrency |
Bitmask identifying concurrency control options for scrollable cursors. |
SQL_Scroll_Options |
Bitmask indicating scroll options for scrollable cursors. |
SQL_Search_Pattern_Escape |
See the Microsoft ODBC 3.5 Programmer’s Reference and SDK Guide for information. |
SQL_Set_Database_Context |
Sybase/Intersolv extension for supporting CSPs. If value = Y, the driver issues use_database_name to the configured database name and is sensitive to three-part names. |
SQL_Special_Characters |
Special characters used in object names. All characters except a–z, A–Z, 0–9, and the underscore character. |
SQL_SQL_Conformance |
A value indicating the level of SQL-92 supported by the driver. |
SQL_String_Functions |
Bitmask indicating supported scalar string functions. |
SQL_Subqueries |
Bitmask indicating predicates that support subqueries. |
SQL_System_Functions |
Bitmask indicating supported scalar system functions. |
SQL_TimeDate_Add_Intervals |
Bitmask indicating supported timestamp intervals associated with TIMESTAMPADD function. |
SQL_TimeDate_Diff_Intervals |
Bitmask indicating supported timestamp intervals associated with TIMESTAMPDIFF function. |
SQL_TimeDate_Functions |
Bitmask indicating supported timestamp intervals. |
SQL_TXN_Capable |
Indicates the transaction support in the DBMS. |
SQL_TXN_Isolation_Option |
Bitmask indicating transaction isolation levels. |
SQL_Union |
Bitmask indicating support for union clause. |
SQL_User_Name |
Current user name. A maximum of SQL_Max_User_Name_Len characters are returned. A null value means not supported. |