16.13 Information types that can be specified for InfoType in SQLGetInfo and SQLGetInfoW
The following table lists and describes the information types that can be specified for InfoType.
No. |
Information type (InfoType) |
Description (convention) |
Return value |
Data type |
---|---|---|---|---|
1 |
SQL_ACCESSIBLE_PROCEDURES |
One of the following values:
|
Returns N. |
|
2 |
SQL_ACCESSIBLE_TABLES |
One of the following values:
|
Returns Y. |
|
3 |
SQL_ACTIVE_ENVIRONMENTS |
Maximum number of active environments that the driver supports. If no limit is specified or the limit is unknown, 0 is returned. |
Returns 0. |
SQLUSMALLINT |
4 |
SQL_AGGREGATE_FUNCTIONS |
Support status for aggregation functions. |
Returns the following bit strings:
|
SQLUINTEGER |
5 |
SQL_ALTER_DOMAIN |
The clauses in the ALTER DOMAIN statement that are supported by the data source. A return value of 0 means that the ALTER DOMAIN statement is not supported. |
Returns 0. |
SQLUINTEGER |
6 |
SQL_ALTER_TABLE |
The clauses in the ALTER TABLE statement that are supported by the data source. |
Returns the following bit string according to the value specified for the SQL_ATTR_ODBC_VERSION environment handle:
|
SQLUINTEGER |
7 |
SQL_ASYNC_MODE |
The driver's asynchronous support level. |
Returns SQL_AM_NONE. |
SQLUINTEGER |
8 |
SQL_BATCH_ROW_COUNT |
The driver's behavior on available row counts. |
Returns 0. |
SQLUINTEGER |
9 |
SQL_BATCH_SUPPORT |
The driver's support for batches. |
Returns 0. |
SQLUINTEGER |
10 |
SQL_BOOKMARK_PERSISTENCE |
Processing for which bookmarks are enabled. |
Returns 0. |
SQLUINTEGER |
11 |
SQL_CATALOG_LOCATION |
A value indicating the position of the catalog in a qualified table name. |
Returns 0. |
SQLUSMALLINT |
12 |
SQL_CATALOG_NAME |
One of the following values:
|
Returns N. |
|
13 |
SQL_CATALOG_NAME_SEPARATOR |
A string of one or more characters that is defined as a separator. This separator is placed between a catalog name and the element that follows or precedes it. If the data source does not support catalogs, a null character string is returned. |
Returns a null character string. |
|
14 |
SQL_CATALOG_TERM |
The data source vendor's name as a catalog. If the data source does not support catalogs, a null character string is returned. |
Returns a null character string. |
|
15 |
SQL_CATALOG_USAGE |
The statements in which catalogs can be used. If the data source does not support catalogs, 0 is returned. |
Returns 0. |
SQLUINTEGER |
16 |
SQL_COLLATION_SEQ |
The name of the collation sequence (default collation for the server's default character set). If the name is unknown, a null character string is returned. |
Returns a null character string. |
|
17 |
SQL_COLUMN_ALIAS |
One of the following values:
|
Returns Y. |
|
18 |
SQL_CONCAT_NULL_BEHAVIOR |
How the data source concatenates NULL-valued character string data type columns with non-NULL-valued character string data type columns. |
Returns SQL_CB_NULL. |
SQLUSMALLINT |
19 |
SQL_CONVERT_BIGINT |
Conversions by the CONVERT scalar function that are supported by the data source. |
Returns the following bit strings:
|
SQLUINTEGER |
20 |
SQL_CONVERT_BINARY |
Returns the following bit strings:
|
SQLUINTEGER |
|
21 |
SQL_CONVERT_BIT |
Returns 0. |
SQLUINTEGER |
|
22 |
SQL_CONVERT_CHAR |
Returns the following bit strings:
|
SQLUINTEGER |
|
23 |
SQL_CONVERT_DATE |
Returns the following bit strings:
|
SQLUINTEGER |
|
24 |
SQL_CONVERT_DECIMAL |
Returns the following bit strings:
|
SQLUINTEGER |
|
25 |
SQL_CONVERT_DOUBLE |
Returns the following bit strings:
|
SQLUINTEGER |
|
26 |
SQL_CONVERT_FLOAT |
Returns 0. |
SQLUINTEGER |
|
27 |
SQL_CONVERT_INTEGER |
Returns the following bit strings:
|
SQLUINTEGER |
|
28 |
SQL_CONVERT_INTERVAL_YEAR_MONTH |
Returns 0. |
SQLUINTEGER |
|
29 |
SQL_CONVERT_INTERVAL_DAY_TIME |
Returns 0. |
SQLUINTEGER |
|
30 |
SQL_CONVERT_LONGVARBINARY |
Returns 0. |
SQLUINTEGER |
|
31 |
SQL_CONVERT_LONGVARCHAR |
Returns 0. |
SQLUINTEGER |
|
32 |
SQL_CONVERT_NUMERIC |
Returns 0. |
SQLUINTEGER |
|
33 |
SQL_CONVERT_REAL |
Returns 0. |
SQLUINTEGER |
|
34 |
SQL_CONVERT_SMALLINT |
Returns 0. |
SQLUINTEGER |
|
35 |
SQL_CONVERT_TIME |
Returns the following bit strings:
|
SQLUINTEGER |
|
36 |
SQL_CONVERT_TIMESTAMP |
Returns the following bit strings:
|
SQLUINTEGER |
|
37 |
SQL_CONVERT_TINYINT |
Returns 0. |
SQLUINTEGER |
|
38 |
SQL_CONVERT_VARBINARY |
Returns the following bit strings:
|
SQLUINTEGER |
|
39 |
SQL_CONVERT_VARCHAR |
Returns the following bit strings:
|
SQLUINTEGER |
|
40 |
SQL_CONVERT_FUNCTIONS |
The scalar conversion functions that are supported by the driver and associated data source. |
Returns the following bit strings:
|
SQLUINTEGER |
41 |
SQL_CORRELATION_NAME |
Whether table correlation names are supported. |
Returns SQL_CN_ANY. |
SQLUSMALLINT |
42 |
SQL_CREATE_ASSERTION |
The clauses in the CREATE ASSERTION statement that are supported by the data source. A return value of 0 means that the CREATE ASSERTION statement is not supported. |
Returns 0. |
SQLUINTEGER |
43 |
SQL_CREATE_CHARACTER_SET |
The clauses in the CREATE CHARACTER SET statement that are supported by the data source. A return value of 0 means that the CREATE CHARACTER SET statement is not supported. |
Returns 0. |
SQLUINTEGER |
44 |
SQL_CREATE_COLLATION |
The clauses in the CREATE COLLATION statement that are supported by the data source. A return value of 0 means that the CREATE COLLATION statement is not supported. |
Returns 0. |
SQLUINTEGER |
45 |
SQL_CREATE_DOMAIN |
The clauses in the CREATE DOMAIN statement that are supported by the data source. A return value of 0 means that the CREATE DOMAIN statement is not supported. |
Returns 0. |
SQLUINTEGER |
46 |
SQL_CREATE_SCHEMA |
The clauses in the CREATE SCHEMA statement that are supported by the data source. A return value of 0 means that the CREATE SCHEMA statement is not supported. |
Returns SQL_CS_CREATE_SCHEMA. |
SQLUINTEGER |
47 |
SQL_CREATE_TABLE |
The clauses in the CREATE TABLE statement that are supported by the data source. A return value of 0 means that the CREATE TABLE statement is not supported. |
Returns the following bit strings:
|
SQLUINTEGER |
48 |
SQL_CREATE_TRANSLATION |
The clauses in the CREATE TRANSLATION statement that are supported by the data source. A return value of 0 means that the CREATE TRANSLATION statement is not supported. |
Returns 0. |
SQLUINTEGER |
49 |
SQL_CREATE_VIEW |
The clauses in the CREATE VIEW statement that are supported by the data source. A return value of 0 means that the CREATE VIEW statement is not supported. |
Returns SQL_CV_CREATE_VIEW. |
SQLUINTEGER |
50 |
SQL_CURSOR_COMMIT_BEHAVIOR |
The effects of COMMIT processing on cursors and prepared statements in the data source. |
Returns SQL_CB_CLOSE. |
SQLUSMALLINT |
51 |
SQL_CURSOR_ROLLBACK_BEHAVIOR |
The effects of ROLLBACK processing on cursors and prepared statements in the data source. |
Returns SQL_CB_CLOSE. |
SQLUSMALLINT |
52 |
SQL_CURSOR_SENSITIVITY |
Support for cursor sensitivity. |
Returns SQL_UNSPECIFIED. |
SQLUINTEGER |
53 |
SQL_DATA_SOURCE_NAME |
The data source name character string that is used during connection. |
Returns an empty string or the data source name that was used during connection. |
|
54 |
SQL_DATA_SOURCE_READ_ONLY |
One of the following values:
|
Returns N. |
|
55 |
SQL_DATABASE_NAME |
A character string with the name of the database in use, if the data source defines a named object called "database". |
Returns a null character string. |
|
56 |
SQL_DATETIME_LITERALS |
The SQL-92 datetime literals that are supported by the data source. |
Returns the following bit strings:
|
SQLUINTEGER |
57 |
SQL_DBMS_NAME |
A character string that indicates the name of the DBMS product accessed by the driver. |
Returns "Hitachi Advanced Data Binder". |
|
58 |
SQL_DBMS_VER |
A character string that indicates the version of the DBMS product accessed by the driver. The version is displayed in the format ##.##.####. |
Returns the DBMS product version. |
|
59 |
SQL_DDL_INDEX |
Support for creation and dropping of indexes. |
Returns the following bit strings:
|
SQLUINTEGER |
60 |
SQL_DEFAULT_TXN_ISOLATION |
The default transaction isolation level supported by the driver or data source. |
Returns SQL_TXN_READ_COMMITTED. |
SQLUINTEGER |
61 |
SQL_DESCRIBE_PARAMETER |
One of the following values:
|
Returns Y. |
|
62 |
SQL_DM_VER |
A character string for the version of the driver manager. The version is represented in the format ##.##.####.####. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
|
63 |
SQL_DRIVER_HDBC |
The driver's connection handle, which can be determined by InfoType. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
SQLUINTEGER |
64 |
SQL_DRIVER_HDESC |
The driver's descriptor handle that is determined by the descriptor handle of the driver manager. This information must be set in *InfoValuePtr and passed by the application. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
SQLUINTEGER |
65 |
SQL_DRIVER_HENV |
The driver's environment handle, which can be determined by InfoType. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
SQLUINTEGER |
66 |
SQL_DRIVER_HLIB |
The hinst that is returned from the load library to the driver manager when the driver DLL or its equivalent is loaded. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
SQLUINTEGER |
67 |
SQL_DRIVER_HSTMT |
The driver's statement handle that is determined by the driver manager's statement handle. This information must be set in *InfoValuePtr and passed by the application. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
SQLUINTEGER |
68 |
SQL_DRIVER_NAME |
A character string that indicates the driver's file name used to access the data source. |
Returns the driver's file name. |
|
69 |
SQL_DRIVER_ODBC_VER |
A character string that indicates the ODBC version supported by the driver. The version is represented in the format ##.##. |
Returns the ODBC version supported by the driver. |
|
70 |
SQL_DRIVER_VER |
A character string that indicates the driver's version. Normally the driver returns this value. The minimum value for the version is represented in the format ##.##.####. |
Returns the driver's version. |
|
71 |
SQL_DROP_ASSERTION |
The clauses in the DROP ASSERTION statement (defined in SQL-92) that are supported by the data source. |
Returns 0. |
SQLUINTEGER |
72 |
SQL_DROP_CHARACTER_SET |
The clauses in the DROP CHARACTER SET statement (defined in SQL-92) that are supported by the data source. |
Returns 0. |
SQLUINTEGER |
73 |
SQL_DROP_COLLATION |
The clauses in the DROP COLLATION statement (defined in SQL-92) that are supported by the data source. |
Returns 0. |
SQLUINTEGER |
74 |
SQL_DROP_DOMAIN |
The clauses in the DROP DOMAIN statement (defined in SQL-92) that are supported by the data source. |
Returns 0. |
SQLUINTEGER |
75 |
SQL_DROP_SCHEMA |
The clauses in the DROP SCHEMA statement (defined in SQL-92) that are supported by the data source. |
Returns the following bit strings:
|
SQLUINTEGER |
76 |
SQL_DROP_TABLE |
The clauses in the DROP TABLE statement (defined in SQL-92) that are supported by the data source. |
Returns the following bit strings:
|
SQLUINTEGER |
77 |
SQL_DROP_TRANSLATION |
The clauses in the DROP TRANSLATION statement that are supported by the data source. |
Returns 0. |
SQLUINTEGER |
78 |
SQL_DROP_VIEW |
The clauses in the DROP VIEW statement that are supported by the data source. |
Returns SQL_DV_DROP_VIEW. |
SQLUINTEGER |
79 |
SQL_DYNAMIC_CURSOR_ATTRIBUTES1 |
Attributes of a dynamic cursor that is supported by the driver. This bitmask contains the first subset of attributes. |
Returns 0. |
SQLUINTEGER |
80 |
SQL_DYNAMIC_CURSOR_ATTRIBUTES2 |
Attributes of a dynamic cursor that is supported by the driver. This bitmask contains the second subset of attributes. |
Returns 0. |
SQLUINTEGER |
81 |
SQL_EXPRESSIONS_IN_ORDERBY |
One of the following values:
|
Returns Y. |
|
82 |
SQL_FILE_USAGE |
How the single-tier driver directly handles files in a data source. |
Returns SQL_FILE_NOT_SUPPORTED. |
SQLUSMALLINT |
83 |
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 |
Attributes of a forward-only cursor that is supported by the driver. This bitmask contains the first subset of attributes. |
Returns 0. |
SQLUINTEGER |
84 |
SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 |
Attributes of a forward-only cursor that is supported by the driver. This bitmask contains the second subset of attributes. |
Returns 0. |
SQLUINTEGER |
85 |
SQL_GETDATA_EXTENSIONS |
Extensions to SQLGetData. |
Returns the following values:
|
SQLUINTEGER |
86 |
SQL_GROUP_BY |
The relationship between the columns in the GROUP BY clause and the columns in the selection list to which a set function has not been applied. |
Returns SQL_GB_GROUP_BY_CONTAINS_SELECT. |
SQLUSMALLINT |
87 |
SQL_IDENTIFIER_CASE |
Information about identifiers in SQL statements. |
Returns SQL_IC_UPPER. |
SQLUSMALLINT |
88 |
SQL_IDENTIFIER_QUOTE_CHAR |
The character string that is used as the starting and ending delimiter of a quoted identifier in SQL statements. If the data source does not support quoted identifiers, a blank is returned. |
Returns a double quotation mark ("). |
|
89 |
SQL_INDEX_KEYWORDS |
Keywords in the CREATE INDEX statement that are supported by the driver. |
Returns the following bit strings:
|
SQLUINTEGER |
90 |
SQL_INFO_SCHEMA_VIEWS |
The views in INFORMATION_SCHEMA that are supported by the driver. |
Returns 0. |
SQLUINTEGER |
91 |
SQL_INSERT_STATEMENT |
Support for INSERT statements. |
Returns the following bit strings:
|
SQLUINTEGER |
92 |
SQL_INTEGRITY |
One of the following values:
|
Returns N. |
|
93 |
SQL_KEYSET_CURSOR_ATTRIBUTES1 |
Attributes of a keyset cursor that is supported by the driver. This bitmask contains the first subset of attributes. |
Returns 0. |
SQLUINTEGER |
94 |
SQL_KEYSET_CURSOR_ATTRIBUTES2 |
Attributes of a keyset cursor that is supported by the driver. This bitmask contains the second subset of attributes. |
Returns 0. |
SQLUINTEGER |
95 |
SQL_KEYWORDS |
A character string that contains a comma-separated list of all keywords specific to the data source. This list does not contain keywords specific to ODBC or keywords used by both the data source and ODBC. This list represents all the reserved keywords. |
Returns HADB's reserved words without the ODBC-specific keywords. |
|
96 |
SQL_LIKE_ESCAPE_CLAUSE |
One of the following values:
|
Returns Y. |
|
97 |
SQL_MAX_ASYNC_CONCURRENT_STATEMENTS |
Maximum number of active concurrent statements in asynchronous mode that the driver can support on a specified connection. If there is no specific limit or the limit is unknown, 0 is returned. |
Returns 0. |
SQLUINTEGER |
98 |
SQL_MAX_BINARY_LITERAL_LEN |
Maximum length of a binary literal in an SQL statement. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 64000. |
SQLUINTEGER |
99 |
SQL_MAX_CATALOG_NAME_LEN |
Maximum length of a catalog name. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 0. |
SQLUSMALLINT |
100 |
SQL_MAX_CHAR_LITERAL_LEN |
Maximum length of a character literal in an SQL statement. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 32000. |
SQLUINTEGER |
101 |
SQL_MAX_COLUMN_NAME_LEN |
Maximum length of a column name in the data source. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 100. |
SQLUSMALLINT |
102 |
SQL_MAX_COLUMNS_IN_GROUP_BY |
Maximum number of grouping columns permitted in a GROUP BY clause. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 64. |
SQLUSMALLINT |
103 |
SQL_MAX_COLUMNS_IN_INDEX |
Maximum number of columns permitted in an index. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 16. |
SQLUSMALLINT |
104 |
SQL_MAX_COLUMNS_IN_ORDER_BY |
Maximum number of columns permitted in an ORDER BY clause. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 16. |
SQLUSMALLINT |
105 |
SQL_MAX_COLUMNS_IN_SELECT |
Maximum number of columns permitted in a selection list. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 1000. |
SQLUSMALLINT |
106 |
SQL_MAX_COLUMNS_IN_TABLE |
Maximum number of columns permitted in a table. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 1000. |
SQLUSMALLINT |
107 |
SQL_MAX_CONCURRENT_ACTIVITIES |
Maximum number of active statements that the driver supports for a connection. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 0. |
SQLUSMALLINT |
108 |
SQL_MAX_CURSOR_NAME_LEN |
Maximum length of a cursor name in the data source. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 0. |
SQLUSMALLINT |
109 |
SQL_MAX_DRIVER_CONNECTIONS |
Maximum number of active connections that the driver supports for an environment. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 0. |
SQLUSMALLINT |
110 |
SQL_MAX_IDENTIFIER_LEN |
Maximum length of a character string that the data source supports for user-defined names. |
Returns 100. |
SQLUSMALLINT |
111 |
SQL_MAX_INDEX_SIZE |
Maximum length (in bytes) permitted for the combined fields of an index. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 4036. |
SQLUINTEGER |
112 |
SQL_MAX_PROCEDURE_NAME_LEN |
Maximum length of a procedure name in the data source. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 0. |
SQLUSMALLINT |
113 |
SQL_MAX_ROW_SIZE |
Maximum length of a row permitted in a table. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 0. |
SQLUINTEGER |
114 |
SQL_MAX_ROW_SIZE_INCLUDES_LONG |
One of the following values:
|
Returns N. |
|
115 |
SQL_MAX_SCHEMA_NAME_LEN |
Maximum length of a schema name in the data source. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 100. |
SQLUSMALLINT |
116 |
SQL_MAX_STATEMENT_LEN |
Maximum length (in characters) of an SQL statement. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 16000000. |
SQLUINTEGER |
117 |
SQL_MAX_TABLE_NAME_LEN |
Maximum length of a data source table name. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 100. |
SQLUSMALLINT |
118 |
SQL_MAX_TABLES_IN_SELECT |
Maximum number of tables permitted in the FROM clause of a SELECT statement. If there is no specified limit or the limit is unknown, 0 is returned. |
Returns 64. |
SQLUSMALLINT |
119 |
SQL_MAX_USER_NAME_LEN |
Maximum length of a user name in the data source. If there is no maximum length or the length is unknown, 0 is returned. |
Returns 100. |
SQLUSMALLINT |
120 |
SQL_MULT_RESULT_SETS |
One of the following values:
|
Returns N. |
|
121 |
SQL_MULTIPLE_ACTIVE_TXN |
One of the following values:
|
Returns Y. |
|
122 |
SQL_NEED_LONG_DATA_LEN |
One of the following values:
|
Returns Y. |
|
123 |
SQL_NON_NULLABLE_COLUMNS |
Whether NOT NULL columns in the data source are supported. |
Returns SQL_NNC_NON_NULL. |
SQLUSMALLINT |
124 |
SQL_NULL_COLLATION |
Where NULL is sorted in a result set. |
Returns SQL_NC_HIGH. |
SQLUSMALLINT |
125 |
SQL_NUMERIC_FUNCTIONS |
The numeric functions supported by the driver and data source. |
Returns the following bit strings:
|
SQLUINTEGER |
126 |
SQL_ODBC_INTERFACE_CONFORMANCE |
Level of the ODBC 3.x interface that the driver complies with. |
Returns SQL_OIC_CORE. |
SQLUINTEGER |
127 |
SQL_ODBC_VER |
A character string containing the version of ODBC with which the driver manager conforms. The version is represented in the format ##.##.0000. This information type is implemented by the driver manager. |
Returns the value that is set by the driver manager. |
|
128 |
SQL_OJ_CAPABILITIES |
The types of outer joins supported by the driver and data source. |
Returns the following bit strings:
|
SQLUINTEGER |
129 |
SQL_ORDER_BY_COLUMNS_IN_SELECT |
One of the following values:
|
Returns N. |
|
130 |
SQL_PARAM_ARRAY_ROW_COUNTS |
The driver's properties regarding the availability of row counts in a parameterized execution. |
Returns 0. |
SQLUINTEGER |
131 |
SQL_PARAM_ARRAY_SELECTS |
The driver's properties regarding the availability of result sets in a parameterized execution. |
Returns SQL_PAS_NO_SELECT. |
SQLUINTEGER |
132 |
SQL_PROCEDURE_TERM |
A character string containing the data source vendor's name for a procedure. |
Returns a null character string. |
|
133 |
SQL_PROCEDURES |
One of the following values:
|
Returns N. |
|
134 |
SQL_QUOTED_IDENTIFIER_CASE |
Information about quoted identifiers in SQL statements. |
Returns SQL_IC_SENSITIVE. |
SQLUSMALLINT |
135 |
SQL_ROW_UPDATES |
One of the following values:
|
Returns N. |
|
136 |
SQL_SCHEMA_TERM |
A character string containing the data source vendor's name for a schema. |
Returns "schema". |
|
137 |
SQL_SCHEMA_USAGE |
The statements in which schemas can be used. |
Returns the following bit strings:
|
SQLUINTEGER |
138 |
SQL_SCROLL_OPTIONS |
Scroll options supported for scrollable cursors. |
Returns SQL_SO_FORWARD_ONLY. |
SQLUINTEGER |
139 |
SQL_SEARCH_PATTERN_ESCAPE |
A character string indicating that the driver supports an escape character that uses the pattern search metacharacters underscore (_) and percent sign (%) as valid characters in search patterns. This indicates an escape character that handles metacharacters underscore (_) and percent sign (%) for pattern search as valid search characters. This escape character applies only to the arguments of catalog functions that support search character strings. If a null character string is specified, the driver cannot handle underscore (_) and percent sign (%) as a part of search pattern character strings. |
Returns "\". |
|
140 |
SQL_SERVER_NAME |
A character string containing the actual data source-specific server name. |
Returns "Hitachi Advanced Data Binder". |
|
141 |
SQL_SPECIAL_CHARACTERS |
A character string that contains all special characters that can be used in an identifier name (such as a table name, column name, or index name) in the data source. |
Returns a null character string. |
|
142 |
SQL_SQL_CONFORMANCE |
The level of SQL-92 supported by the driver. |
Returns SQL_SC_SQL92_ENTRY. |
SQLUINTEGER |
143 |
SQL_SQL92_DATETIME_FUNCTIONS |
The datetime scalar functions that are supported by the driver and the associated data source. |
Returns the following bit strings:
|
SQLUINTEGER |
144 |
SQL_SQL92_FOREIGN_KEY_DELETE_RULE |
The rules supported for a foreign key in a DELETE statement. |
Returns 0. |
SQLUINTEGER |
145 |
SQL_SQL92_FOREIGN_KEY_UPDATE_RULE |
The rules supported for a foreign key in an UPDATE statement. |
Returns 0. |
SQLUINTEGER |
146 |
SQL_SQL92_GRANT |
The clauses supported in a GRANT statement. |
Returns the following bit strings:
|
SQLUINTEGER |
147 |
SQL_SQL92_NUMERIC_VALUE_FUNCTIONS |
The numeric scalar functions supported by the driver and associated data source. |
Returns the following bit string:
|
SQLUINTEGER |
148 |
SQL_SQL92_PREDICATES |
The predicates supported in a SELECT statement. |
Returns the following bit strings:
|
SQLUINTEGER |
149 |
SQL_SQL92_RELATIONAL_JOIN_OPERATORS |
The relational join operators supported in a SELECT statement. |
Returns the following bit strings:
|
SQLUINTEGER |
150 |
SQL_SQL92_REVOKE |
The clauses supported in a REVOKE statement that is supported by the data source. |
Returns the following bit strings:
|
SQLUINTEGER |
151 |
SQL_SQL92_ROW_VALUE_CONSTRUCTOR |
The row value constructor expressions supported in a SELECT statement. |
Returns 0. |
SQLUINTEGER |
152 |
SQL_SQL92_STRING_FUNCTIONS |
The string scalar functions supported by the driver and associated data source. |
Returns the following bit strings:
|
SQLUINTEGER |
153 |
SQL_SQL92_VALUE_EXPRESSIONS |
Supported value expressions. |
Returns the following bit strings:
|
SQLUINTEGER |
154 |
SQL_STANDARD_CLI_CONFORMANCE |
The CLI standard with which the driver conforms. |
Returns SQL_SCC_ISO92_CLI. |
SQLUINTEGER |
155 |
SQL_STATIC_CURSOR_ATTRIBUTES1 |
Attributes of a static cursor that is supported by the driver. This bitmask contains the first subset of attributes. |
Returns 0. |
SQLUINTEGER |
156 |
SQL_STATIC_CURSOR_ATTRIBUTES2 |
Attributes of a static cursor that is supported by the driver. This bitmask contains the second subset of attributes. |
Returns 0. |
SQLUINTEGER |
157 |
SQL_STRING_FUNCTIONS |
The string scalar functions supported by the data source. |
Returns the following bit strings:
|
SQLUINTEGER |
158 |
SQL_SUBQUERIES |
The predicates that support subqueries. |
Returns the following bit strings:
|
SQLUINTEGER |
159 |
SQL_SYSTEM_FUNCTIONS |
The system scalar functions supported by the driver and associated data source. |
Returns 0. |
SQLUINTEGER |
160 |
SQL_TABLE_TERM |
A character string containing the data source vendor's name for a table. |
Returns "table". |
|
161 |
SQL_TIMEDATE_ADD_INTERVALS |
The time stamp interval supported by the driver and associated data source for the TIMESTAMPADD scalar function. |
Returns 0. |
SQLUINTEGER |
162 |
SQL_TIMEDATE_DIFF_INTERVALS |
The time stamp interval supported by the driver and associated data source for the TIMESTAMPDIFF scalar function. |
Returns 0. |
SQLUINTEGER |
163 |
SQL_TIMEDATE_FUNCTIONS |
The date and time scalar functions supported by the driver and associated data source. |
Returns the following bit strings:
|
SQLUINTEGER |
164 |
SQL_TXN_CAPABLE |
The transactions supported by the driver or data source. |
Returns SQL_TC_DDL_COMMIT. |
SQLUSMALLINT |
165 |
SQL_TXN_ISOLATION_OPTION |
The transaction isolation levels available from the driver or data source. |
Returns the following bit strings:
|
SQLUINTEGER |
166 |
SQL_UNION |
Support for the UNION clause. |
Returns the following bit strings:
|
SQLUINTEGER |
167 |
SQL_USER_NAME |
A character string containing the name that is used in a specific database. This might be different from the login name. |
Returns the user name that was used for connection. |
|
168 |
SQL_XOPEN_CLI_YEAR |
A character string that indicates the year of publication of the X/Open specification with which the version of the ODBC driver manager fully compiles. |
Returns the value that is set by the driver manager. |
|
169 |
SQL_ODBC_API_CONFORMANCE |
Value of SQLSMALLINT that indicates the ODBC conformance level. |
Returns SQL_OAC_LEVEL1. |
SQLUSMALLINT |
170 |
SQL_FETCH_DIRECTION |
The supported fetch direction options. |
Returns SQL_FD_FETCH_NEXT. |
SQLUINTEGER |
171 |
SQL_LOCK_TYPES |
The lock types that can be specified in the fLock argument of SQLSetPos. |
Returns 0. |
SQLUINTEGER |
172 |
SQL_ODBC_SAG_CLI_CONFORMANCE |
The compliance level to functions of the SAG specification. |
Returns SQL_OSCC_COMPLIANT. |
SQLUSMALLINT |
173 |
SQL_ODBC_SQL_CONFORMANCE |
The SQL grammar supported by the driver. |
Returns SQL_OSC_CORE. |
SQLUSMALLINT |
174 |
SQL_OUTER_JOINS |
Support status for outer joins of data sources. |
Returns F. |
|
175 |
SQL_POS_OPERATIONS |
The operations supported by SQLSetPos. |
Returns 0. |
SQLUINTEGER |
176 |
SQL_POSITIONED_STATEMENTS |
The positioned SQL statements supported by the data source. |
Returns 0. |
SQLUINTEGER |
177 |
SQL_SCROLL_CONCURRENCY |
The concurrency control options supported for scrollable cursors. |
Returns SQL_SCCO_READ_ONLY. |
SQLUINTEGER |
178 |
SQL_STATIC_SENSITIVITY |
Whether an application can detect changes made to a static or keyset-driven cursor through the following:
|
Returns 0. |
SQLUINTEGER |