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