3.2 Responses to SQLGetInfo | ODBC and SQL Reference

Applications call the SQLGetInfo function to retrieve details about support a specific driver and data source provide for different ODBC functionality.

Applications supply the InfoType argument to SQLGetInfo to specify what information type they seek. SQLGetInfo returns the information to the InfoValuePtr output argument. Table 3–1 lists each InfoType argument the ODBC Driver recognizes along with the associated value returned to SQLGetInfo. Shaded rows indicate information types renamed or deprecated for ODBC 3.0.

For more detail about the SQLGetInfo function see the Microsoft ODBC Programmer’s Reference.

**Table 3–1.** Information the ODBC Driver Returns to SQLGetInfo
Description	InfoType Argument	Returns
Shaded rows indicate information types renamed or deprecated for ODBC 3.0
Guaranteed execute privileges on all procedures returned by SQLProcedures	`SQL_ACCESSIBLE_PROCEDURES`	Y (guaranteed)
Guaranteed read access to all table names returned by SQLTables	`SQL_ACCESSIBLE_TABLES`	N (not guaranteed)
Maximum number of active connections	`SQL_ACTIVE_CONNECTIONS` (Renamed for ODBC 3.0.)	See `SQL_MAX_DRIVER_CONNECTIONS`
Maximum number of active environments	`SQL_ACTIVE_ENVIRONMENTS` (ODBC 3.0)	0 (no limit)
Maximum number of active SQL statements	`SQL_ACTIVE_STATEMENTS` (Renamed for ODBC 3.0.)	See `SQL_MAX_CONCURRENT_ACTIVITIES`
Aggregate function support	`SQL_AGGREGATE_FUNCTIONS` (ODBC 3.0)	SQL_AF_ALL \| SQL_AF_AVG \| SQL_AF_COUNT \| SQL_AF_DISTINCT \| SQL_AF_MAX \| SQL_AF_MIN \| SQL_AF_SUM
Support for ALTER DOMAIN statement	`SQL_ALTER_DOMAIN` (ODBC 3.0)	0 (does not support)
Support for ALTER SCHEMA statement	`SQL_ALTER_SCHEMA` (ODBC 3.0)	0 (does not support)
Support for ALTER TABLE clauses	`SQL_ALTER_TABLE`	SQL_AT_ADD_COLUMN (supports adding columns)
Level of asynchronous mode support	`SQL_ASYNC_MODE` (ODBC 3.0)	SQL_AM_NONE (not supported)
Behavior with respect to the availability of row counts in batches	`SQL_BATCH_ROW_COUNT` (ODBC 3.0)	0 (does not support)
Support for batches	`SQL_BATCH_SUPPORT` (ODBC 3.0)	SQL_BS_ROW_COUNT_EXPLICIT (supports explicit batches with row-count generating statements)
Support for bookmarks	`SQL_BOOKMARK_PERSISTENCE`	0 (does not support)
Position of qualifier in a qualified table name	`SQL_CATALOG_LOCATION` (Renamed for ODBC 3.0. Was SQL_QUALIFIER_LOCATION)	SQL_QL_START (at the start of the name)
Support for catalog names	`SQL_CATALOG_NAME` (ODBC 3.0)	N (does not support)
Character used to separate table, column qualifiers	`SQL_CATALOG_NAME_SEPARATOR` (Renamed for ODBC 3.0. Was SQL_QUALIFIER_NAME_SEPARATOR)	. (period)
Name for a catalog	`SQL_CATALOG_TERM` (Renamed for ODBC 3.0. Was SQL_QUALIFIER_TERM)	"" (does not support)
Statements that support catalog names	`SQL_CATALOG_USAGE` (Renamed for ODBC 3.0. Was SQL_QUALIFIER_USAGE)	0 (does not support)
Default collation sequence name for the default character set	`SQL_COLLATION_SEQ` (ODBC 3.0)	“ ” (unknown)
Support for column aliases	`SQL_COLUMN_ALIAS`	Y (supports)
Result of concatenation of NULL character column with non-NULL column	`SQL_CONCAT_NULL_BEHAVIOR`	SQL_CB_NULL (result is null)
Conversion from BIGINT	`SQL_CONVERT_BIGINT`	SQL_CVT_CHAR\| SQL_CVT_NUMERIC\| SQL_CVT_TINYINT\| SQL_CVT_SMALLINT\| SQL_CVT_INTEGER\| SQL_CVT_FLOAT\| SQL_CVT_DOUBLE\| SQL_CVT_BIT
Conversion from BINARY	`SQL_CONVERT_BINARY`	SQL_CVT_CHAR \| SQL_CVT_BINARY
Conversion from BIT	`SQL_CONVERT_BIT`	SQL_CVT_CHAR \| SQL_CVT_NUMERIC \| SQL_CVT_BIT \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_BIGINT \| SQL_CVT_INTEGER \| SQL_CVT_FLOAT \| SQL_CVT_REAL
Conversion from CHAR	`SQL_CONVERT_CHAR`	SQL_CVT_BIT \| SQL_CVT_BINARY \| SQL_CVT_NUMERIC \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_BIGINT \| SQL_CVT_DATE \| SQL_CVT_FLOAT \| SQL_CVT_TIME \| SQL_CVT_TIMESTAMP \| SQL_CVT_CHAR
Conversion from DATE	`SQL_CONVERT_DATE`	SQL_CVT_CHAR \| SQL_CVT_DATE \| SQL_CVT_TIMESTAMP
Conversion from DECIMAL	`SQL_CONVERT_DECIMAL`	0 (does not support)
Conversion from DOUBLE	`SQL_CONVERT_DOUBLE`	0 (does not support)
Conversion from FLOAT	`SQL_CONVERT_FLOAT`	SQL_CVT_CHAR \| SQL_CVT_NUMERIC \| SQL_CVT_BIT \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_BIGINT \| SQL_CVT_INTEGER \| SQL_CVT_FLOAT \| SQL_CVT_REAL
Support for conversion functions	`SQL_CONVERT_FUNCTIONS`	SQL_FN_CVT_CONVERT (supports)
Conversion from INTEGER	`SQL_CONVERT_INTEGER`	SQL_CVT_CHAR \| SQL_CVT_NUMERIC \| SQL_CVT_BIT \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_BIGINT \| SQL_CVT_INTEGER \| SQL_CVT_FLOAT \| SQL_CVT_REAL
Conversion from INTERVAL_DAY_TIME	`SQL_CONVERT_INTERVAL_DAY_TIME` (ODBC 3.0)	0 (does not support)
Conversion from INTERVAL_YEAR_MONTH	`SQL_CONVERT_INTERVAL_YEAR_MONTH` (ODBC 3.0)	0 (does not support)
Conversion from LONGVARBINARY	`SQL_CONVERT_LONGVARBINARY`	0 (does not support)
Conversion from LONGVARCHAR	`SQL_CONVERT_LONGVARCHAR`	0 (does not support)
Conversion from NUMERIC	`SQL_CONVERT_NUMERIC`	SQL_CVT_CHAR \| SQL_CVT_INTEGER \| SQL_CVT_FLOAT \| SQL_CVT_REAL \| SQL_CVT_BIT \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_BIGINT
Conversion from REAL	`SQL_CONVERT_REAL`	SQL_CVT_CHAR \| SQL_CVT_NUMERIC \| SQL_CVT_BIT \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_BIGINT \| SQL_CVT_INTEGER \| SQL_CVT_FLOAT \| SQL_CVT_DOUBLE
Conversion from SMALLINT	`SQL_CONVERT_SMALLINT`	SQL_CVT_CHAR \| SQL_CVT_NUMERIC \| SQL_CVT_INTEGER \| SQL_CVT_BIGINT \| SQL_CVT_FLOAT \| SQL_CVT_DOUBLE \| SQL_CVT_TINYINT \| SQL_CVT_SMALLINT \| SQL_CVT_NUMERIC \| SQL_CVT_BIT
Conversion from TIME	`SQL_CONVERT_TIME`	SQL_CVT_CHAR \| SQL_CVT_TIME \| SQL_CVT_TIMESTAMP
Conversion from TIMESTAMP	`SQL_CONVERT_TIMESTAMP`	SQL_CVT_CHAR \| SQL_CVT_DATE
Conversion from TINYINT	`SQL_CONVERT_TINYINT`	SQL_CVT_CHAR \| SQL_CVT_NUMERIC \| SQL_CVT_BIT \| SQL_CVT_SMALLINT \| SQL_CVT_INTEGER \| SQL_CVT_BIGINT \| SQL_CVT_FLOAT \| SQL_CVT_DOUBLE \| SQL_CVT_TINYINT
Conversion from VARBINARY	`SQL_CONVERT_VARBINARY`	0 (does not support)
Conversion from VARCHAR	`SQL_CONVERT_VARCHAR`	0 (does not support)
Support for table correlation names	`SQL_CORRELATION_NAME`	SQL_CN_DIFFERENT (supports, but correlation names must be different from table name)
Support for CREATE ASSERTION statement	`SQL_CREATE_ASSERTION` (ODBC 3.0)	0 (does not support)
Support for CREATE CHARACTER SET statement	`SQL_CREATE_CHARACTER_SET` (ODBC 3.0)	0 (does not support)
Support for CREATE COLLATION statement	`SQL_CREATE_COLLATION` (ODBC 3.0)	0 (does not support)
Support for CREATE DOMAIN statement	`SQL_CREATE_DOMAIN` (ODBC 3.0)	0 (does not support)
Support for CREATE SCHEMA statement	`SQL_CREATE_SCHEMA` (ODBC 3.0)	0 (does not support)
Support for CREATE TABLE statement	`SQL_CREATE_TABLE` (ODBC 3.0)	SQL_CT_CREATE_TABLE \| SQL_CT_COMMIT_DELETE \| SQL_CT_COLUMN_CONSTRAINT \| SQL_CT_TABLE_CONSTRAINT (supports CREATE TABLE, deleted rows are deleted on commit, supports column constraints and table constraints)
Support for CREATE TRANSLATION statement	`SQL_CREATE_TRANSLATION` (ODBC 3.0)	0 (does not support)
Support for CREATE VIEW statement	`SQL_CREATE_VIEW` (ODBC 3.0)	SQL_CV_CREATE_VIEW \| SQL_CV_CHECK_OPTION (supports CREATE VIEW, CHECK OPTION clause)
Effect of COMMIT operation on cursors and prepared statements	`SQL_CURSOR_COMMIT_BEHAVIOR`	SQL_CB_CLOSE (closes cursors but statements remain in prepared state)
Effect of ROLLBACK operation on cursors and prepared statements	`SQL_CURSOR_ROLLBACK_BEHAVIOR`	SQL_CB_CLOSE (closes cursors but statements remain in prepared state)
Support for cursor sensitivity	`SQL_CURSOR_SENSITIVITY` (ODBC 3.0)	SQL_INSENSITIVE (all cursors on the statement handle show the result set without reflecting any changes made to it by any other cursor within the same transaction)
Name of the data source as specified to the ODBC Administrator	`SQL_DATA_SOURCE_NAME`	(string containing the name)
Access limited to read-only	`SQL_DATA_SOURCE_READ_ONLY`	N (read-write access)
Name of the Dharma/SQL data source on the server system	`SQL_DATABASE_NAME`	(string containing the name)
Support for date-time literals	`SQL_DATETIME_LITERALS` (ODBC 3.0)	SQL_DL_SQL92_DATE \| SQL_DL_SQL92_TIME \| SQL_DL_SQL92_TIMESTAMP
Name of the database product supporting the data source	`SQL_DBMS_NAME`	Dharma/SQL
Version of the database product	`SQL_DBMS_VER`	6.2.1
Support for creation and dropping of indexes	`SQL_DDL_INDEX` (ODBC 3.0)	SQL_DI_CREATE_INDEX \| SQL_DI_DROP_INDEX (supports)
Default transaction isolation level	`SQL_DEFAULT_TXN_ISOLATION`	SQL_TXN_SERIALIZABLE
Suppport for describing parameters via DESCRIBE INPUT statement	`SQL_DESCRIBE_PARAMETER` (ODBC 3.0)	Y (supports)
Name of the dynamic link library file for the ODBC Driver	`SQL_DRIVER_NAME`	DHODBC.DLL
Supported ODBC version	`SQL_DRIVER_ODBC_VER`	03.00
Current Version of the ODBC Driver	`SQL_DRIVER_VER`	06.20.1000
Support for DROP ASSERTION statement	`SQL_DROP_ASSERTION` (ODBC 3.0)	0 (does not support)
Support for DROP CHARACTER SET statement	`SQL_DROP_CHARACTER_SET` (ODBC 3.0)	0 (does not support)
Support for DROP COLLATION statement	`SQL_DROP_COLLATION` (ODBC 3.0)	0 (does not support)
Support for DROP DOMAIN statement	`SQL_DROP_DOMAIN` (ODBC 3.0)	0 (does not support)
Support for DROP SCHEMA statement	`SQL_DROP_SCHEMA` (ODBC 3.0)	0 (does not support)
Support for DROP TABLE statement	`SQL_DROP_TABLE` (ODBC 3.0)	SQL_DT_DROP_TABLE (supports)
Support for DROP TRANSLATION statement	`SQL_DROP_TRANSLATION` (ODBC 3.0)	0 (does not support)
Support for DROP VIEW statement	`SQL_DROP_VIEW` (ODBC 3.0)	SQL_DT_DROP_VIEW (supports)
Supported attributes of a dynamic cursor: subset 1	`SQL_DYNAMIC_CURSOR_ATTRIBUTES1` (ODBC 3.0)	0 (does not support dynamic cursors)
Supported attributes of a dynamic cursor: subset 2	`SQL_DYNAMIC_CURSOR_ATTRIBUTES2` (ODBC 3.0)	0 (does not support dynamic cursors)
Support for expressions in ORDER BY clause	`SQL_EXPRESSIONS_IN_ORDERBY`	Y (supports)
Direction that FETCH operations can support	`SQL_FETCH_DIRECTION` (Deprecated in ODBC 3.0.)	SQL_FD_FETCH_NEXT (fetch next row only)
Single-tier driver behavior	`SQL_FILE_USAGE`	SQL_FILE_NOT_SUPPORTED (not a single-tier driver)
Supported attributes of a forward-only cursor: subset 1	`SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1` (ODBC 3.0)	SQL_CA1_NEXT (supports SQL_FETCH_NEXT argument to SQLFetchScroll for forward-only cursors)
Supported attributes of a forward-only cursor: subset 2	`SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2` (ODBC 3.0)	SQL_CA2_READ_ONLY_CONCURRENCY
Supported extensions to SQLGetData	`SQL_GETDATA_EXTENSIONS`	0 (does not support)
Relationship between GROUP BY clause and columns in the select list	`SQL_GROUP_BY`	SQL_GB_GROUP_BY_CONTAINS_SELECT (GROUP BY clause must contain all non-aggregated columns in select list)
Case-sensitivity of user-supplied names	`SQL_IDENTIFIER_CASE`	SQL_IC_LOWER (case insensitive, stored in lower case)
Character used to enclose delimited identifiers	`SQL_IDENTIFIER_QUOTE_CHAR`	" (double quotation mark)
Supported views in INFORMATION_SCHEMA	`SQL_INFO_SCHEMA_VIEWS` (ODBC 3.0)	0 (does not support)
Support for INSERT statement	`SQL_INSERT_STATEMENT` (ODBC 3.0)	SQL_IS_INSERT_LITERALS \| SQL_IS_INSERT_SEARCHED \| SQL_IS_SELECT_INTO
Referential integrity syntax support	`SQL_INTEGRITY` (Renamed for ODBC 3.0. Was SQL_ODBC_SQL_OPT_IEF)	Y (supports referential integrity syntax)
Supported attributes of a keyset cursor: subset 1	`SQL_KEYSET_CURSOR_ATTRIBUTES1` (ODBC 3.0)	0 (does not support keyset cursors)
Supported attributes of a keyset cursor: subset 2	`SQL_KEYSET_CURSOR_ATTRIBUTES2` (ODBC 3.0)	0 (does not support keyset cursors)
Data-source specific keywords	`SQL_KEYWORDS`	absolute, action, add, all, allocate, and,any, are, as, asc, assertion, at, authorization, alter, avg, atta, begin, between, bit_length, bigint, bitstrig, binary, bit, both, by, cascade, cascaded, call, case, cast, catalog, char, character, char_length, character_length, check, close, cluster, coalesce, collate, collation, column, colroup_kw, colon, comma, commit, compress, concat, connect, connection, constraint, constraint_kw, constraints, continue, convert, corresponding, count, crete, cross, current, current_date, current_time, current_timestamp, current_user, cursor, database, datapages, date, day, deallocate, dec, decimal, declare, default, default_kw, deferrable, deferred, deinition, delete, describe, delete_kw, desc, describe, descriptor, diagnostics, disconnect, distint, div, domain, double, drop, dot, dh_f64_t, dba, end, else, end, end-exec, eqtok, escape, except, exception, exclusiv, exec, execute, exists, external, extract, false, fetch, file_kw, first, float, dh_f32_t, for, foreign, foreign_kw, fortran, found, from, full, e_tok, gt_tok, get, global, go, goto, grant, group, hash, having, hour, identified, identifier, identity, immediate, in, in_kw, include, index, indicator, inexpages, initially, inner, input, insensitive, insert, int, integer, intersect, interval, into, is, isolation, join, key, key_kw, language, last, leading, left, level, le_tok, like, lin, lt_tok, local, lock, log, long_kw, lower, lvarbinary, lvarchar, lpar, match, max, max_kw, min, min_kw, minu, minute, modify, mode, module, money, month, names, national, natural, nchar, ne_tok, next, no, nocompress, none, not, null, null_kw, nullif, number, numeric, nowait, octet_length, of, on,only, open, option, or, order, outer, outer_join, output, overlaps, pad, partial, pascal, pctfree, plus, position, precision, prepare, preserve, primary, primary_kw, prior, privileges, public, question, raw, read, real, realnumber, references, references_kw, relative, rename, resource, restrict, revoke, right, rollback, rows, rowid, rownum, rpar, schema, scroll, second, select, session, session_user, set, set_minus, share, size, smallint, some, space, sql, sqlca, sqlcode, sqlerror, sqlstate, sqlwarning, star, storage_manager, store_in_dharma, statistics, sring, substring, sum, synonym, sysdate, system_user, systime, systimestamp, table, temporary, then, time, timestamp, timezone_hour, timezone_minute, tinyint, to, trailing, transaction, trim, true, uid, union, unique, unknown, update, upper, usage, user, using, value, values, varbinary, varchar, varying, view, when, whenever, where, with, work, write, year, zone, ascade, odbcec, odbcet, odbcone, coment, odbces, odbcset
Support for escape clause in LIKE predicates	`SQL_LIKE_ESCAPE_CLAUSE`	Y (supports)
Supported lock types	`SQL_LOCK_TYPES` (Deprecated in ODBC 3.0.)	0 (does not support)
Maximum number of active concurrent statements in asynchronous mode	`SQL_MAX_ASYNC_CONCURRENT_STATEMENTS` (ODBC 3.0)	0 (no limit)
Maximum length in hexadecimal characters of binary literals	`SQL_MAX_BINARY_LITERAL_LEN`	2000
Maximum length of a table or column qualifier	`SQL_MAX_CATALOG_NAME_LEN` (Renamed for ODBC 3.0. Was SQL_MAX_QUALIFIER_NAME_LEN)	0 (does not support)
Maximum length in characters of character string literals	`SQL_MAX_CHAR_LITERAL_LEN`	2000
Maximum length of a column name	`SQL_MAX_COLUMN_NAME_LEN`	32
Maximum number of columns allowed in GROUP BY clause	`SQL_MAX_COLUMNS_IN_GROUP_BY`	0 (no limit)
Maximum number of columns allowed in an index	`SQL_MAX_COLUMNS_IN_INDEX`	100
Maximum number of columns allowed in ORDER BY clause	`SQL_MAX_COLUMNS_IN_ORDER_BY`	0 (no limit)
Maximum number of columns allowed in a select list	`SQL_MAX_COLUMNS_IN_SELECT`	0 (no limit)
Maximum number of columns allowed in a table	`SQL_MAX_COLUMNS_IN_TABLE`	500
Maximum number of active SQL statements	`SQL_MAX_CONCURRENT_ACTIVITIES` (Renamed for ODBC 3.0. Was SQL_ACTIVE_STATEMENTS)	0 (no maximum)
Maximum length of a cursor name	`SQL_MAX_CURSOR_NAME_LEN`	32
Maximum number of active connections	`SQL_MAX_DRIVER_CONNECTIONS` (Renamed for ODBC 3.0. Was SQL_ACTIVE_CONNECTIONS)	10
Maximum length of user-defined names	`SQL_MAX_IDENTIFIER_LEN` (ODBC 3.0)	32
Maximum number of bytes allowed in the combined fields of an index	`SQL_MAX_INDEX_SIZE`	0 (no limit)
Maximum length of an owner name	`SQL_MAX_OWNER_NAME_LEN` (Renamed for ODBC 3.0.)	See `SQL_MAX_SCHEMA_NAME_LEN`
Maximum length of a procedure name	`SQL_MAX_PROCEDURE_NAME_LEN`	32
Maximum length of a table or column qualifier	`SQL_MAX_QUALIFIER_NAME_LEN` (Renamed for ODBC 3.0.)	See `SQL_MAX_CATALOG_NAME_LEN`
Maximum length in bytes of a table row	`SQL_MAX_ROW_SIZE`	0 (no limit)
Whether maximum row size includes LONGVARCHAR and LONGVARBINARY	`SQL_MAX_ROW_SIZE_INCLUDES_LONG`	Y
Maximum length of an owner name	`SQL_MAX_SCHEMA_NAME_LEN` (Renamed for ODBC 3.0. Was SQL_MAX_OWNER_NAME_LEN)	32
Maximum number of characters in a SQL statement	`SQL_MAX_STATEMENT_LEN`	25000
Maximum length of a table name	`SQL_MAX_TABLE_NAME_LEN`	32
Maximum number of tables allowed in FROM clause	`SQL_MAX_TABLES_IN_SELECT`	250
Maximum length of a user name	`SQL_MAX_USER_NAME_LEN`	32
Support for multiple result sets	`SQL_MULT_RESULT_SETS`	N (does not support)
Support for active transactions on multiple connections	`SQL_MULTIPLE_ACTIVE_TXN`	Y (supports)
Whether data source requires length of LONGVARCHAR and LONGVARBINARY data	`SQL_NEED_LONG_DATA_LEN`	N
Support for NOT NULL clause in CREATE TABLE statement	`SQL_NON_NULLABLE_COLUMNS`	SQL_NNC_NON_NULL (supports)
Where null values are sorted in a list	`SQL_NULL_COLLATION`	SQL_NC_LOW (sorted at the low end of the list)
Numeric functions supported	`SQL_NUMERIC_FUNCTIONS`	SQL_FN_NUM_ABS \| SQL_FN_NUM_ACOS \| SQL_FN_NUM_ASIN \| SQL_FN_NUM_ATAN \| SQL_FN_NUM_ATAN2 \| SQL_FN_NUM_CEILING \| SQL_FN_NUM_COS \| SQL_FN_NUM_DEGREES \| SQL_FN_NUM_EXP \| SQL_FN_NUM_FLOOR \| SQL_FN_NUM_LOG10 \| SQL_FN_NUM_LOG \| SQL_FN_NUM_MOD \| SQL_FN_NUM_PI \| SQL_FN_NUM_POWER \| SQL_FN_NUM_RADIANS \| SQL_FN_NUM_RAND \| SQL_FN_NUM_SIGN \| SQL_FN_NUM_SIN \| SQL_FN_NUM_SQRT \| SQL_FN_NUM_TAN (bit masks specifying support for indicated functions)
ODBC API conformance level	`SQL_ODBC_API_CONFORMANCE` (Deprecated in ODBC 3.0.)	SQL_OAC_LEVEL1 (supports level 1)
SQL Access Group (SAG) conformance	`SQL_ODBC_SAG_CLI_CONFORMANCE`	SQL_OSCC_COMPLIANT (complies with SAG CLI specification)
ODBC SQL syntax conformance	`SQL_ODBC_SQL_CONFORMANCE` (Deprecated in ODBC 3.0.)	SQL_OSC_EXTENDED (supports extended SQL syntax as defined by ODBC)
Referential integrity syntax support	`SQL_ODBC_SQL_OPT_IEF` (Renamed for ODBC 3.0.)	See `SQL_INTEGRITY`
ODBC version supported by driver manager	`SQL_ODBC_VER`	Returned by ODBC driver manager
Whether columns in ORDER BY clause must also be in select list	`SQL_ORDER_BY_COLUMNS_IN_SELECT`	N
Support for outer joins	`SQL_OUTER_JOINS`	Y (supports)
Term for entity that has owner privileges on objects	`SQL_OWNER_TERM` (Renamed for ODBC 3.0.)	See `SQL_SCHEMA_TERM`
Statements that support use of owner qualifiers	`SQL_OWNER_USAGE` (Renamed for ODBC 3.0.)	See `SQL_SCHEMA_USAGE`
Characteristics of row counts available in a parameterized execution	`SQL_PARAM_ARRAY_ROW_COUNTS` (ODBC 3.0)	SQL_PARC_NO_BATCH (only one row count available, which is the cumulative row count resulting from the execution of the statement for the entire array of parameters)
Characteristics of result sets available in a parameterized execution	`SQL_PARAM_ARRAY_SELECTS` (ODBC 3.0)	0 (does not support)
Supported operations in SQLSetPos	`SQL_POS_OPERATION` (Deprecated in ODBC 3.0.)	0 (does not support SQLSetPos)
Statements that support positioned operations	`SQL_POSITIONED_STATEMENTS` (Deprecated in ODBC 3.0.)	SQL_PS_POSITIONED_DELETE \| SQL_PS_POSITIONED_UPDATE \| SQL_PS_SELECT_FOR_UPDATE
Term for procedures	`SQL_PROCEDURE_TERM`	procedure
SQL procedures support	`SQL_PROCEDURES`	Y (supports SQL procedures)
Position of qualifier in a qualified table name	`SQL_QUALIFIER_LOCATION` (Renamed for ODBC 3.0.)	See `SQL_CATALOG_LOCATION`
Character used to separate table, column qualifiers	`SQL_QUALIFIER_NAME_SEPARATOR` (Renamed for ODBC 3.0.)	See `SQL_CATALOG_NAME_SEPARATOR`
Term for object that qualifies table names	`SQL_QUALIFIER_TERM` (Renamed for ODBC 3.0.)	See `SQL_CATALOG_TERM`
Statements that support qualifiers	`SQL_QUALIFIER_USAGE` (Renamed for ODBC 3.0.)	See `SQL_CATALOG_USAGE`
Case-sensitivity of quoted user-supplied names	`SQL_QUOTED_IDENTIFIER_CASE`	SQL_IC_SENSITIVE (case sensitive, stored in mixed case)
Detect changes to any row in mixed-cursor operations	`SQL_ROW_UPDATES`	Y
Term for entity that has owner privileges on objects	`SQL_SCHEMA_TERM` (Renamed for ODBC 3.0. Was SQL_OWNER_TERM)	owner
Statements that support use of owner qualifiers	`SQL_SCHEMA_USAGE` (Renamed for ODBC 3.0. Was SQL_OWNER_USAGE)	SQL_OU_DML_STATEMENTS \| SQL_OU_PROCEDURE_INVOCATION \| SQL_OU_TABLE_DEFINITION \| SQL_OU_INDEX_DEFINITION \| SQL_OU_PRIVILEGE_DEFINITION
Concurrency control options supported for scrollable cursors	`SQL_SCROLL_CONCURRENCY` (Deprecated in ODBC 3.0.)	0 (does not support)
Options supported for scrollable cursors	`SQL_SCROLL_OPTIONS`	SQL_SO_FORWARD_ONLY
Character to permit wildcard characters in search strings	`SQL_SEARCH_PATTERN_ESCAPE`	\ (backslash)
Name of the system where the Dharma/SQL data source resides	`SQL_SERVER_NAME`	(string containing the name)
Special characters allowed in user-supplied names	`SQL_SPECIAL_CHARACTERS`	_ (underscore)
Level of SQL-92 support	`SQL_SQL_CONFORMANCE` (ODBC 3.0)	SQL_SC_SQL92_ENTRY (entry level SQL-92 compliant)
Datetime scalar functions supported	`SQL_SQL92_DATETIME_FUNCTIONS` (ODBC 3.0)	SQL_SDF_CURRENT_DATE \| SQL_SDF_CURRENT_TIME
Behavior of DELETE statement that refers to a foreign key	`SQL_SQL92_FOREIGN_KEY_DELETE_RULE` (ODBC 3.0)	SQL_SFKU_NO_ACTION
Behavior of UPDATE statement that refers to a foreign key	`SQL_SQL92_FOREIGN_KEY_UPDATE_RULE` (ODBC 3.0)	SQL_SFKU_NO_ACTION
GRANT statement clauses supported	`SQL_SQL92_GRANT` (ODBC 3.0)	SQL_SG_DELETE_TABLE \| SQL_SG_INSERT_TABLE \| SQL_SG_INSERT_COLUMN \| SQL_SG_REFERENCES_TABLE \| SQL_SG_REFERENCES_COLUMN \| SQL_SG_SELECT_TABLE \| SQL_SG_UPDATE_TABLE \| SQL_SG_UPDATE_COLUMN
Numeric scalar functions supported	`SQL_SQL92_NUMERIC_VALUE_FUNCTIONS` (ODBC 3.0)	SQL_SNVF_CHAR_LENGTH \| SQL_SNVF_CHARACTER_LENGTH
Predicates supported	`SQL_SQL92_PREDICATES` (ODBC 3.0)	SP_EXISTS \| SQL_SP_ISNOTNULL \| SQL_SP_ISNULL \| SQL_SP_UNIQUE \| SQL_SP_LIKE \| SQL_SP_IN \| SQL_SP_BETWEEN
Relational join operators supported	`SQL_SQL92_RELATIONAL_JOIN_OPERATORS` (ODBC 3.0)	SQL_SRJO_INNER_JOIN \| SQL_SRJO_LEFT_OUTER_JOIN \| SQL_SRJO_NATURAL_JOIN \| SQL_SRJO_RIGHT_OUTER_JOIN
REVOKE statement clauses supported	`SQL_SQL92_REVOKE` (ODBC 3.0)	SQL_SR_GRANT_OPTION_FOR \| SQL_SR_CASCADE \| SQL_SR_RESTRICT \| SQL_SR_DELETE_TABLE \| SQL_SR_INSERT_TABLE \| SQL_SR_INSERT_COLUMN \| SQL_SR_REFERENCES_TABLE \| SQL_SR_REFERENCES_COLUMN \| SQL_SR_SELECT_TABLE \| SQL_SR_UPDATE_TABLE \| SQL_SR_UPDATE_COLUMN
Row value constructor expressions supported	`SQL_SQL92_ROW_VALUE_CONSTRUCTOR` (ODBC 3.0)	0 (does not support)
String scalar functions supported	`SQL_SQL92_STRING_FUNCTIONS` (ODBC 3.0)	SQL_SSF_CONVERT \| SQL_SSF_LOWER \| SQL_SSF_UPPER \| SQL_SSF_SUBSTRING \| SQL_SSF_TRANSLATE \| SQL_SSF_TRIM_LEADING \| SQL_SSF_TRIM_TRAILING
Value expressions supported	`SQL_SQL92_VALUE_EXPRESSIONS` (ODBC 3.0)	SQL_SVE_CASE \| SQL_SVE_CAST \| SQL_SVE_COALESCE \| SQL_SVE_NULLIF
CLI standards to which the driver conforms	`SQL_STANDARD_CLI_CONFORMANCE` (ODBC 3.0)	SQL_SCC_XOPEN_CLI_VERSION1 (conforms to X/Open CLI version 1)
Supported attributes of a static cursor: subset 1	`SQL_STATIC_CURSOR_ATTRIBUTES1` (ODBC 3.0)	SQL_CA1_NEXT (supports SQL_FETCH_NEXT argument to SQLFetchScroll for static cursors)
Supported attributes of a static cursor: subset 2	`SQL_STATIC_CURSOR_ATTRIBUTES2` (ODBC 3.0)	0 (does not support any attributes in the subset))
Whether static cursor changes are detectable	`SQL_STATIC_SENSITIVITY` (Deprecated in ODBC 3.0.)	0 (does not support static cursors)
String functions supported	`SQL_STRING_FUNCTIONS`	SQL_FN_STR_CONCAT \| SQL_FN_STR_INSERT \| SQL_FN_STR_LEFT \| SQL_FN_STR_LTRIM \| SQL_FN_STR_LENGTH \| SQL_FN_STR_LOCATE \| SQL_FN_STR_LCASE \| SQL_FN_STR_REPEAT \| SQL_FN_STR_REPLACE \| SQL_FN_STR_RTRIM \| SQL_FN_STR_SUBSTRING \| SQL_FN_STR_UCASE \| SQL_FN_STR_ASCII \| SQL_FN_STR_CHAR \| SQL_FN_STR_DIFFERENCE \| SQL_FN_STR_SOUNDEX \| SQL_FN_STR_SPACE \| SQL_FN_STR_CHAR_LENGTH \| SQL_FN_STR_CHARACTER_LENGTH
Predicates that support subqueries	`SQL_SUBQUERIES`	SQL_SQ_CORRELATED_SUBQUERIES \| SQL_SQ_COMPARISON \| SQL_SQ_EXISTS \| SQL_SQ_IN \| SQL_SQ_QUANTIFIED
System functions supported	`SQL_SYSTEM_FUNCTIONS`	SQL_FN_SYS_DBNAME \| SQL_FN_SYS_IFNULL \| SQL_FN_SYS_USERNAME
Term for tables	`SQL_TABLE_TERM`	table
Timestamp intervals supported for TIMESTAMPADD function	`SQL_TIMEDATE_ADD_INTERVALS`	SQL_TSI_FRAC_SECOND \| SQL_TSI_SECOND \| SQL_TSI_MINUTE \| SQL_TSI_HOUR \| SQL_TSI_DAY \| SQL_TSI_WEEK \| SQL_TSI_MONTH \| SQL_TSI_QUARTER \| SQL_TSI_YEAR
Timestamp intervals supported for TIMESTAMPDIFF function	`SQL_TIMEDATE_DIFF_INTERVALS`	SQL_TSI_FRAC_SECOND \| SQL_TSI_SECOND \| SQL_TSI_MINUTE \| SQL_TSI_HOUR \| SQL_TSI_DAY \| SQL_TSI_WEEK \| SQL_TSI_MONTH \| SQL_TSI_QUARTER \| SQL_TSI_YEAR
Date-time functions supported	`SQL_TIMEDATE_FUNCTIONS`	SQL_FN_TD_NOW \| SQL_FN_TD_CURDATE \| SQL_FN_TD_DAYNAME \| SQL_FN_TD_DAYOFMONTH \| SQL_FN_TD_DAYOFWEEK \| SQL_FN_TD_DAYOFYEAR \| SQL_FN_TD_MONTH \| SQL_FN_TD_MONTHNAME \| SQL_FN_TD_QUARTER \| SQL_FN_TD_WEEK \| SQL_FN_TD_YEAR \| SQL_FN_TD_CURTIME \| SQL_FN_TD_HOUR \| SQL_FN_TD_MINUTE \| SQL_FN_TD_SECOND \| SQL_FN_TD_TIMESTAMPADD \| SQL_FN_TD_TIMESTAMPDIFF
Support for DML, DDL within transactions	`SQL_TXN_CAPABLE`	SQL_TC_ALL (supports both DML and DDL)
Options for setting transaction isolation levels	`SQL_TXN_ISOLATION_OPTION`	SQL_TXN_READ_UNCOMMITTED \| SQL_TXN_READ_COMMITTED \| SQL_TXN_REPEATABLE_READ \| SQL_TXN_SERIALIZABLE
UNION support	`SQL_UNION`	SQL_U_UNION \| SQL_U_UNION_ALL
Name of user connected to the data source	`SQL_USER_NAME`	(string containing the name)