This topic details the information the ODBC Driver returns to SQLGetInfo.

The following table describes return values the ODBC driver returns to SQLGetInfo.

Table 1. Information the ODBC driver returns to SQLGetInfo
Description fInfoType argument Returns
Guaranteed execute privileges on all procedures returned by SQLProcedures SQL_ACCESSIBLE_PROCEDURES N
Guaranteed read access to all table names returned by SQLTables SQL_ACCESSIBLE_TABLES N
Maximum number of active connections SQL_ACTIVE_CONNECTIONS 0
Maximum number of active statements supported for an active connection SQL_ACTIVE_STATEMENTS 100
Maximum number of active environments SQL_ACTIVE_ENVIRONMENTS 0
Support for ALTER DOMAIN statement SQL_ALTER_DOMAIN 0x00000000
Support for ALTER TABLE clauses SQL_ALTER_TABLE 0x00000000
SQL Conformance SQL_SQL_CONFORMANCE SQL_SC_SQL92_ENTRY
Support for datetime literals SQL_DATETIME_LITERALS 0x00000000
Level of asynchronous mode support SQL_ASYNC_MODE SQL_AM_NONE
Behavior with respect to the availability of row counts in batches SQL_BATCH_ROW_COUNT 0x00000000
Support for batches SQL_BATCH_SUPPORT 0x00000000
Support for bookmarks SQL_BOOKMARK_PERSISTENCE SQL_BP_UPDATE SQL_BP_SCROLL
Position of qualifier in a qualified table name SQL_CATALOG_LOCATION SQL_CL_START
Support for catalog names SQL_CATALOG_NAME Y
Character used to separate table, column qualifiers SQL_CATALOG_NAME_SEPARATOR " ."
Term for object that qualifies table names SQL_CATALOG_TERM "database"
Statements that support qualifiers SQL_CATALOG_USAGE SQL_CU_DML_STATEMENTS

SQL_CU_PROCEDURE_INVOCATION
Default collation sequence name for the default character set SQL_COLLATION_SEQ " "
Support for column aliases SQL_COLUMN_ALIAS Y
Result of concatenation of NULL character column with non‑NULL column SQL_CONCAT_NULL_BEHAVIOR SQL_CB_NULL = 0
Conversion from BIGINT SQL_CONVERT_BIGINT SQL_CVT_CHAR

SQL_CVT_BIGINT

SQL_CVT_TINYINT

SQL_CVT_SMALLINT

SQL_CVT_INTEGER

SQL_CVT_FLOAT

SQL_CVT_DOUBLE
Conversion from BINARY SQL_CONVERT_BINARY 0x00000000
Conversion from BIT SQL_CONVERT_BIT 0x00000000
Conversion from CHAR SQL_CONVERT_CHAR SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT

SQL_CVT_DATE

SQL_CVT_TIMESTAMP
Conversion from DATE SQL_CONVERT_DATE SQL_CVT_CHAR

SQL_CVT_VARCHAR

SQL_CVT_DATE

SQL_CVT_TIMESTAMP
Conversion from DECIMAL SQL_CONVERT_DECIMAL SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Conversion from DOUBLE SQL_CONVERT_DOUBLE SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Conversion from FLOAT SQL_CONVERT_FLOAT SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Support for conversion functions SQL_CONVERT_FUNCTIONS SQL_FN_CVT_CONVERT
Conversion from INTEGER SQL_CONVERT_INTEGER SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Conversion from INTERVAL_DAY_TIME SQL_CONVERT_INTERVAL_ DAY_TIME 0x00000000
Conversion from INTERVAL_YEAR_MONTH SQL_CONVERT_INTERVAL_ YEAR_MONTH 0x00000000
Conversion from INTERVAL_DAY_TIME SQL_CONVERT_INTERVAL_DAY_TIME 0x00000000
Conversion from LONGVARBINARY. SQL_CONVERT_LONGVARBINARY 0x00000000
Conversion from LONGVARCHAR SQL_CONVERT_LONGVARCHAR 0x00000000
Conversion from NUMERIC SQL_CONVERT_NUMERIC SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Conversion from REAL SQL_CONVERT_REAL SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Conversion from SMALLINT SQL_CONVERT_SMALLINT SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
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_VARCHAR

SQL_CVT_DATE

SQL_CVT_TIME

SQL_CVT_TIMESTAMP
Conversion from TINYINT SQL_CONVERT_TINYINT SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT
Conversion from VARBINARY SQL_CONVERT_VARBINARY 0x00000000
Conversion from VARCHAR SQL_CONVERT_VARCHAR SQL_CVT_CHAR

SQL_CVT_NUMERIC

SQL_CVT_DECIMAL

SQL_CVT_INTEGER

SQL_CVT_SMALLINT

SQL_CVT_FLOAT

SQL_CVT_REAL

SQL_CVT_DOUBLE

SQL_CVT_VARCHAR

SQL_CVT_TINYINT

SQL_CVT_BIGINT

SQL_CVT_DATE

SQL_CVT_TIME

SQL_CVT_TIMESTAMP
Conversion from WCHAR SQL_CONVERT_WCHAR 0x00000000
Conversion from WLONGVARCHAR SQL_CONVERT_WLONGVARCHAR 0x00000000
Conversion from WVARCHAR SQL_CONVERT_WVARCHAR 0x00000000
Support for table correlation names SQL_CORRELATION_NAME SQL_CN_DIFFERENT
Support for CREATE ASSERTIONstatement SQL_CREATE_ASSERTION 0x00000000
Support for CREATE CHARACTER SET statement. SQL_CREATE_CHARACTER SET 0x00000000
Support for CREATE COLLATION statement SQL_CREATE_COLLATION 0x00000000
Support for CREATE DOMAIN statement SQL_CREATE_DOMAIN 0x00000000
Support for CREATE SCHEMA statement SQL_CREATE_SCHEMA 0x00000000
Support for CREATE TABLE statement SQL_CREATE_TABLE SQL_CT_CREATE_TABLE

SQL_CT_COLUMN_CONSTRAINT

SQL_CT_TABLE_CONSTRAINT
Support for CREATE TRANSLATIONstatement SQL_CREATE_TRANSLATION 0x00000000
Support for CREATE VIEW statement SQL_CREATE_VIEW SQL_CV_CREATE_VIEW

SQL_CV_CHECK_OPTION
Effect of COMMIT operation on cursors and prepared statements SQL_CURSOR_COMMIT_BEHAVIOR SQL_CB_PRESERVE
Effect of ROLLBACK operation on cursors and prepared statements SQL_CURSOR_ROLLBACK_BEHAVIOR SQL_CB_PRESERVE
Support for cursor sensitivity SQL_CURSOR_SENSITIVITY SQL_INSENSITIVE
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 Progress SQL‑92 ODBC data source on the server system SQL_DATABASE_NAME (String containing the name)
Name of the database product supporting the data source SQL_DBMS_NAME OPENEDGE
Version of the database product SQL_DBMS_VER 10.1B
Default transaction isolation level SQL_DEFAULT_TXN_ISOLATION SQL_TXN_READ_COMMITTED
Support for describing parameters via DESCRIBE INPUT statement SQL_DESCRIBE_PARAMETER Y (Supports)
Version of the driver manager SQL_DM_VER 03.52.1117.0000
Connection handle determined by the argument InfoType SQL_DRIVER_HDBC 0x017E4538
Driver's descriptor handle determined by the Driver Manager's descriptor handle SQL_DRIVER_HDESC 0x017E68A8
Environment handle determined by the argument InfoType SQL_DRIVER_HENV 0x017E4090
Handle library from the load library returned to the Driver Manager when it loaded the driver DLL SQL_DRIVER_HLIB 0x28660000
Driver's statement handle determined by the Driver Manager's statement handle SQL_DRIVER_HSTMT 0x01828050
Name of the dynamic link library file for the ODBC Driver SQL_DRIVER_NAME Windows

pgoe1022.DLL

AIX, SOLARIS, LINUX

pgoe1022.SO

HPIIX

pgoe1022.SL
Supported ODBC version SQL_DRIVER_ODBC_VER 03.52
Current version of the ODBC Driver SQL_DRIVER_VER 05.20.0039 (b0034, u0022)
Support for DROP ASSERTION statement SQL_DROP_ASSERTION 0x00000000
Support for DROP CHARACTER SET statement SQL_DROP_CHARACTER_SET 0x00000000
Support for DROP COLLATION statement SQL_DROP_COLLATION 0x00000000
Support for DROP DOMAIN statement SQL_DROP_DOMAIN 0x00000000
Support for DROP SCHEMA statement SQL_DROP_SCHEMA 0x00000000
Support for DROP TABLE statement SQL_DROP_TABLE SQL_DT_DROP_TABLE
Support for DROP TRANSLATION statement SQL_DROP_TRANSLATION 0x00000000
Support for DROP VIEW statement SQL_DROP_VIEW SQL_DV_DROP_VIEW
Supported attributes of a dynamic cursor: subset 1 SQL_DYNAMIC_CURSOR_ ATTRIBUTES1 0x00000000
Supported attributes of a dynamic cursor: subset 2 SQL_DYNAMIC_CURSOR_ ATTRIBUTES2 0x00000000
Support for expressions in ORDER BY clause SQL_EXPRESSIONS_IN_ORDERBY Y
Supported fetch direction option. SQL_FETCH_DIRECTION SQL_FD_FETCH_NEXT

SQL_FD_FETCH_FIRST

SQL_FD_FETCH_LAST

SQL_FD_FETCH_PRIOR

SQL_FD_FETCH_ABSOLUTE

SQL_FD_FETCH_RELATIVE

SQL_FD_FETCH_BOOKMARK
Single‑tier driver behavior SQL_FILE_USAGE SQL_FILE_NOT_SUPPORTED
Supported attributes of a forward‑only cursor: subset 1 SQL_FORWARD_ONLY_ CURSOR_ATTRIBUTES1 SQL_CA1_NEXT

SQL_CA1_BULK_ADD
Supported attributes of a forward‑only cursor: subset 2 SQL_FORWARD_ONLY_ CURSOR_ATTRIBUTES2 SQL_CA2_MAX_ROWS_SELECT

SQL_CA2_MAX_ROWS_CATALOG
Supported extensions to SQLGetData SQL_GETDATA_EXTENSIONS SQL_GD_ANY_COLUMN

SQL_GD_ANY_ORDER

SQL_GD_BLOCK

SQL_GD_BOUND
Relationship between GROUP BY clause and columns in the select list SQL_GROUP_BY SQL_GB_GROUP_BY_CONTAINS_SELECT
Case sensitivity of user‑supplied names SQL_IDENTIFIER_CASE SQL_IC_UPPER
Character used to enclose delimited identifiers SQL_IDENTIFIER_QUOTE_CHAR " (Double quotation mark)
Keywords supported in the CREATE INDEX statement SQL_INDEX_KEYWORDS SQL_IK_ASC |SQL_IK_DESC
Supported views in INFORMATION_SCHEMA SQL_INFO_SCHEMA_VIEWS 0x00000000
Support for Integrity Enhancement Facility SQL_INTEGRITY Y
Supported attributes of a keyset cursor: subset 1 SQL_KEYSET_CURSOR_ ATTRIBUTES1 SQL_CA1_NEXT

SQL_CA1_ABSOLUTE

SQL_CA1_RELATIVE

SQL_CA1_BOOKMARK

SQL_CA1_LOCK_NO_CHANGE

SQL_CA1_POS_POSITION

SQL_CA1_POS_UPDATE

SQL_CA1_POS_DELETE

SQL_CA1_POS_REFRESH

SQL_CA1_POSITIONED_UPDATE

SQL_CA1_POSITIONED_DELETE

SQL_CA1_SELECT_FOR_UPDATE

SQL_CA1_BULK_ADD
Supported attributes of a keyset cursor: subset 2 SQL_KEYSET_CURSOR_ ATTRIBUTES2 SQL_CA2_READ_ONLY_CONCURRENCY

SQL_CA2_OPT_VALUES_CONCURRENCY

SQL_CA2_SENSITIVITY_DELETIONS

SQL_CA2_SENSITIVITY_UPDATES

SQL_CA2_MAX_ROWS_SELECT

SQL_CA2_CRC_EXACT

SQL_CA2_SIMULATE_TRY_UNIQUE
Data source specific keywords SQL_KEYWORDS See OpenEdge SQL reserved words for a list of SQL Keywords.
Support for escape clause in LIKE predicates SQL_LIKE_ESCAPE_CLAUSE Y
Support for lock types SQL_LOCK_TYPES SQL_LCK_NO_CHANGE
Maximum number of active concurrent statements in asynchronous mode SQL_MAX_ASYNC_CONCURRENT_STATEMENTS 0
Maximum length in hexadecimal characters of binary literals SQL_MAX_BINARY_LITERAL_LEN 31,983
Maximum length of a table or column qualifier SQL_MAX_CATALOG_NAME_LEN 32
Maximum length in characters of character string literals SQL_MAX_CHAR_LITERAL_LEN 31,983
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 5000
Maximum number of columns allowed in an index SQL_MAX_COLUMNS_IN_INDEX 16
Maximum number of columns allowed in ORDER BY clause SQL_MAX_COLUMNS_IN_ORDER_BY 0
Maximum number of columns allowed in a SELECT list SQL_MAX_COLUMNS_IN_SELECT 5000
Maximum number of columns allowed in a table SQL_MAX_COLUMNS_IN_TABLE 5000
Maximum number of active SQL statements SQL_MAX_CONCURRENT_ACTIVITIES 100
Maximum length of a cursor name SQL_MAX_CURSOR_NAME_LEN 18
Maximum number of active connections SQL_MAX_DRIVER_CONNECTIONS 0
Maximum length of user‑defined names SQL_MAX_IDENTIFIER_LEN 32
Maximum number of bytes allowed in the combined fields of an index SQL_MAX_INDEX_SIZE 115
Maximum length of a procedure name SQL_MAX_PROCEDURE_NAME_LEN 32
Maximum length in bytes of a table row SQL_MAX_ROW_SIZE 31995
Whether maximum row size includes LONGVARCHAR and LONGVARBINARY SQL_MAX_ROW_SIZE_INCLUDES_LONG N
Maximum length of an owner name SQL_MAX_SCHEMA_NAME_LEN 32
Maximum number of characters in an SQL statement SQL_MAX_STATEMENT_LEN 131,000
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
Maximum length of owner name SQL_MAX_OWNER_NAME_LEN 32
Maximum length of a qualifier name SQL_MAX_QUALIFIER_NAME_LEN 32
Support for multiple result sets SQL_MULT_RESULT_SETS N
Support for active transactions on multiple connections SQL_MULTIPLE_ACTIVE_TXN Y
Whether data source requires length of LONGVARCHAR and LONGVARBINARY data SQL_NEED_LONG_DATA_LEN Y
Support for NOT NULL clause in CREATE TABLE statement SQL_NON_NULLABLE_COLUMNS SQL_NNC_NON_NULL
Where NULL values are sorted in a list SQL_NULL_COLLATION SQL_NC_HIGH
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_EXP

SQL_FN_NUM_FLOOR

SQL_FN_NUM_MOD

SQL_FN_NUM_PI

SQL_FN_NUM_POWER

SQL_FN_NUM_RADIANS

SQL_FN_NUM_RAND

SQL_FN_NUM_ROUND

SQL_FN_NUM_SIGN

SQL_FN_NUM_SIN

SQL_FN_NUM_SQRT

SQL_FN_NUM_TAN

SQL_FN_NUM_DEGREES

SQL_FN_NUM_LOG10
Level of ODBC conformance SQL_ODBC_API_CONFORMANCE SQL_OAC_LEVEL1
Level of ODBC 3.x interface conformance SQL_ODBC_INTERFACE_CONFORMANCE SQL_OIC_CORE
SQL Access Group (SAG) conformance SQL_ODBC_SAG_CLI_CONFORMANCE SQL_OSCC_COMPLIANT
Level of SQL conformance SQL_ODBC_SQL_CONFORMANCE SQL_OSC_EXTENDED
Referential integrity syntax support SQL_ODBC_SQL_OPT_IEF Y
ODBC version supported by driver manager SQL_ODBC_VER 03.52.0000
Types of outer joins supported SQL_OJ_CAPABILITIES SQL_OJ_LEFT

SQL_OJ_RIGHT

SQL_OJ_NOT_ORDERED

SQL_OJ_INNER

SQL_OJ_ALL_COMPARISON_OPS
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
Name for an owner SQL_OWNER_TERM owner
Statements in which owner can be used SQL_OWNER_USAGE SQL_OU_DML_STATEMENTS

SQL_OU_PROCEDURE_INVOCATION

SQL_OU_TABLE_DEFINITION

SQL_OU_INDEX_DEFINITION

SQL_OU_PRIVILEGE_DEFINITION
Characteristics of row counts available in a parameterized execution SQL_PARAM_ARRAY_ROW_COUNTS SQL_PARC_NO_BATCH
Characteristics of result sets available in a parameterized execution SQL_PARAM_ARRAY_SELECTS SQL_PAS_NO_SELECT
Supported operations in SQLSetPos SQL_POS_OPERATIONS SQL_POS_POSITION

SQL_POS_REFRESH

SQL_POS_UPDATE

SQL_POS_DELETE

SQL_POS_ADD
Supported positioned SQL statements SQL_POSITIONED_STATEMENTS 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
Support for qualifiers SQL_QUALIFIER_USAGE SQL_CU_DML_STATEMENTS

SQL_CU_PROCEDURE_INVOCATION
Case sensitivity of quoted user‑supplied names SQL_QUOTED_IDENTIFIER_CASE SQL_IC_MIXED
Separator character used between qualifier name and element SQL_QUALIFIER_NAME_SEPARATOR " . "
Term used for a qualifier SQL_QUALIFIER_TERM "database"
Position of the qualifier in a qualified table name SQL_QUALIFIER_LOCATION SQL_CL_START
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 owner
Statements that support use of owner qualifiers SQL_SCHEMA_USAGE SQL_OU_DML_STATEMENTS

SQL_OU_PROCEDURE_INVOCATION

SQL_OU_TABLE_DEFINITION

SQL_OU_INDEX_DEFINITION

SQL_OU_PRIVILEGE_DEFINITION
Options supported for scrollable cursors SQL_SCROLL_OPTIONS SQL_SO_FORWARD_ONLY

SQL_SO_STATIC

SQL_SO_KEYSET_DRIVEN
Support for scrollable cursors SQL_SCROLL_CONCURRENCY SQL_SCCO_READ_ONLY

SQL_SCCO_OPT_VALUES
Character to permit wildcard characters in search strings SQL_SEARCH_PATTERN_ESCAPE \ (Backslash)
Name of the system where the ODBC data source resides SQL_SERVER_NAME (String containing the name)
Special characters allowed in user‑supplied names SQL_SPECIAL_CHARACTERS "_", "%"
Datetime scalar functions supported SQL_SQL92_DATETIME_FUNCTIONS 0x00000000
Behavior of DELETE statement that refers to a foreign key. SQL_SQL92_FOREIGN_KEY_DELETE_RULE 0x00000000
Behavior of UPDATE statement that refers to a foreign key SQL_SQL92_FOREIGN_KEY_UPDATE_RULE 0x00000000
GRANT statement clauses supported SQL_SQL92_GRANT 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 SQL_SNVF_CHAR_LENGTH

SQL_SNVF_CHARACTER_LENGTH
Predicates supported SQL_SQL92_PREDICATES 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 0x00000000
REVOKE statement clauses supported SQL_SQL92_REVOKE 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 0x00000000
String scalar functions supported SQL_SQL92_STRING_FUNCTIONS 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 SQL_SVE_COALESCE

SQL_SVE_NULLIF
CLI standards to which the driver conforms SQL_STANDARD_CLI_CONFORMANCE SQL_SCC_XOPEN_CLI_VERSION1
Supported attributes of a static cursor: subset 1 SQL_STATIC_CURSOR_ATTRIBUTES1 SQL_CA1_NEXT

SQL_CA1_ABSOLUTE

SQL_CA1_RELATIVE

SQL_CA1_BOOKMARK

SQL_CA1_LOCK_NO_CHANGE

SQL_CA1_POS_POSITION

SQL_CA1_POS_UPDATE

SQL_CA1_POS_DELETE

SQL_CA1_POS_REFRESH

SQL_CA1_POSITIONED_UPDATE

SQL_CA1_POSITIONED_DELETE

SQL_CA1_SELECT_FOR_UPDATE

SQL_CA1_BULK_ADD
Supported attributes of a static cursor: subset 2 SQL_STATIC_CURSOR_ATTRIBUTES2 SQL_CA2_READ_ONLY_CONCURRENCY

SQL_CA2_OPT_VALUES_CONCURRENCY

SQL_CA2_SENSITIVITY_UPDATES

SQL_CA2_MAX_ROWS_SELECT

SQL_CA2_CRC_EXACT

SQL_CA2_SIMULATE_TRY_UNIQUE
Support for detection of changes made to a static or key‑set driven cursor through SQLSetPos SQL_STATIC_SENSITIVITY 0x00000000
String functions supported SQL_STRING_FUNCTIONS SQL_FN_STR_CONCAT S

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_RIGHT

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_LOCATE_2

SQL_FN_STR_SPACE

SQL_FN_STR_CHAR_LENGTH

QL_FN_STR_CHARACTER_LENGTH
Predicates that support subqueries SQL_SUBQUERIES SQL_SQ_COMPARISON

SQL_SQ_EXISTS

SQL_SQ_IN

SQL_SQ_QUANTIFIED

SQL_SQ_CORRELATED_SUBQUERIES
System functions supported SQL_SYSTEM_FUNCTIONS SQL_FN_SYS_USERNAME
Term for tables SQL_TABLE_TERM "table"
Timestamp intervals supported for TIMESTAMPADD function SQL_TIMEDATE_ADD_INTERVALS 0x00000000
Timestamp intervals supported for TIMESTAMPDIFF function SQL_TIMEDATE_DIFF_INTERVALS 0x00000000
Date‑time functions supported SQL_TIMEDATE_FUNCTIONS SQL_FN_TD_NOW

SQL_FN_CURDATE

SQL_FN_TD_DAYOFMONTH

SQL_FN_TD_DAYOFWEEK

SQL_FN_TD_DAYOFYEAR

SQL_FN_TD_MONTH

SQL_FN_TD_QUARTER

SQL_FN_TD_WEEK

SQL_FN_TD_YEAR

SQL_FN_CURTIME

SQL_FN_TD_HOUR

SQL_FN_TD_MINUTE

SQL_FN_TD_SECOND

SQL_FN_TD_TIMESTAMP_ADD

SQL_FN_TD_TIMESTAMPDIFF

SQL_FN_TD_DAYNAME

SQL_FN_TD_MONTHNAME
Support for DML, DDL within transactions SQL_TXN_CAPABLE SQL_TC_ALL
Options for setting transaction isolation levels SQL_TXN_ISOLATION_OPTION SQL_TXN_READ_UNCOMMITTED

SQL_TXN_SERIALIZABLE

SQL_TXN_READ_COMMITTED

SQL_TXN_REPEATABLE_READ
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)
Year of publication of the X/Open specification with which the driver complies SQL_XOPEN_CLI_YEAR 1995