Try OpenEdge Now
skip to main content
SQL Reference
ODBC Reference : SQLGetInfo
 

SQLGetInfo

This section details the information the ODBC Driver returns to SQLGetInfo.
The following table describes return values the ODBC driver returns to SQLGetInfo.
Table 65. 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 OpenEdgeSQL 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